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?
Printable View
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?
Code:SELECT [ALL | DISTINCT] column1[,column2]
FROM table1[,table2]
[WHERE "conditions"]
[GROUP BY "column-list"]
[HAVING "conditions]
[ORDER BY "column-list" [ASC | DESC] ]
Tnx! That helped alot.
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