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:
Can Group Functions Be Used in the ORDER BY Clause
Can Group Functions Be Used in the ORDER BY Clause? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: FYIcenter.com
If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many employees are having the same salary in each department. The group output is sorted by the count in each group in descending order:
SQL> SELECT department_id, salary, count(*) 2 FROM employees GROUP BY department_id, 3 salary HAVING count(*) > 1 ORDER BY COUNT(*) DESC; DEPARTMENT_ID SALARY COUNT(*) ------------- ---------- ---------- 50 2500 5 50 3200 4 50 2800 3 80 10000 3 80 9500 3 50 3100 3 50 2600 3 .....
2007-04-20, 4551👍, 0💬
Popular Posts:
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...
What Are Data Pump Export and Import Modes? - Oracle DBA FAQ - Loading and Exporting Data Data pump ...
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the rec...
Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...