SQL and PL/SQL Question: Download SQL and PL/SQL PDF
Sort the Rows in SQL.
Answer:
Sort the Rows:
SELECT column1, column2, ... FROM table_name ORDER BY columnX, columnY, ..
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC, columnY ASC
SELECT column1, column2, ... FROM table_name ORDER BY columnX, columnY, ..
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC, columnY ASC
| Previous Question | Next Question |
| The Delete Statements in SQL. | The IN operator may be used if you know the exact value you want to return for at least one of the columns. |