Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Sort Output in Descending Order
How To Sort Output in Descending Order? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
If you want to sort a column in descending order, you can specify the DESC keyword in the ORDER BY clause. The following SELECT statement first sorts the department in descending order, then sorts the salary in ascending order:
SQL> SELECT department_id, first_name, last_name, salary FROM employees ORDER BY department_id DESC, salary; DEPARTMENT_ID FIRST_NAME LAST_NAME SALARY ------------- --------------- --------------- ---------- Kimberely Grant 7000 110 William Gietz 8300 110 Shelley Higgins 12000 100 Luis Popp 6900 100 Ismael Sciarra 7700 100 Jose Manuel Urman 7800 100 John Chen 8200 100 Daniel Faviet 9000 ......
2007-04-20, 5379👍, 0💬
Popular Posts:
In which event are the controls fully loaded ? Page_load event guarantees that all controls are full...
If cookies are not enabled at browser end does form Authentication work? No, it does not work.
When should the method invokeLater() be used? This method is used to ensure that Swing components ar...
What exactly happens when ASPX page is requested from Browser? Note: - Here the interviewer is expec...
Write out a function that prints out all the permutations of a string. For example, abc would give y...