Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value:
SQL> SELECT department_id, first_name, last_name, salary FROM employees ORDER BY department_id, salary; DEPARTMENT_ID FIRST_NAME LAST_NAME SALARY ------------- --------------- --------------- ---------- 10 Jennifer Whalen 4400 20 Pat Fay 6000 20 Michael Hartstein 13000 30 Karen Colmenares 2500 30 Guy Himuro 2600 30 Sigal Tobias 2800 30 Shelli Baida 2900 30 Alexander Khoo 3100 30 Den Raphaely 11000 40 Susan Mavris 6500 50 TJ Olson 2100 ......
2007-04-20, 4838👍, 0💬
Popular Posts:
How do you target a specific frame from a hyperlink? Include the name of the frame in the target att...
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...
when should the volatile modifier be used? The volatile modifier is a directive to the compiler's op...
What is CodeDom? “CodeDom” is an object model which represents actually a source code. It is designe...
How comfortable are you with writing HTML documents entirely by hand? Everyone has a different prefe...