Results 1 to 4 of 4

Thread: Documentation of SELECT?

  1. Sep 17th, 2000, 01:37 PM #1
    rancor
    rancor is offline

    Thread Starter
    Lively Member
    Join Date
    May 1999
    Posts
    100
    Hi..

    I need to sort a SQL query like 10,9,8..1

    "SELECT * From Stories ORDER BY ID"

    but I need something more.. to revers it..

    And does anyone know where I can find a documentaion of the SELECT query with all parameters?
    Reply With Quote Reply With Quote
  2. Sep 17th, 2000, 02:08 PM #2
    Guest
    Code:
    SELECT [ALL | DISTINCT] column1[,column2]
FROM table1[,table2]
[WHERE "conditions"]
[GROUP BY "column-list"]
[HAVING "conditions]
[ORDER BY "column-list" [ASC | DESC] ]
    Reply With Quote Reply With Quote
  3. Sep 17th, 2000, 03:05 PM #3
    rancor
    rancor is offline

    Thread Starter
    Lively Member
    Join Date
    May 1999
    Posts
    100
    Tnx! That helped alot.
    Reply With Quote Reply With Quote
  4. Sep 17th, 2000, 03:20 PM #4
    Guest
    Glad to help!

    incase you need anymore help,
    there are a few really good websites that I am learning SQL from,

    http://www.sqlcourse.com
    and
    http://www.sqlcourse2.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width