Collections:
Use Group Functions in ORDER BY Clause in Oracle
Can Group Functions Be Used in the ORDER BY Clause in Oracle?
✍: 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 .....
⇒ Ways to Join Two Tables in a Single Query in Oracle
⇐ Use Multiple Columns in GROUP BY in Oracle
2019-10-27, 1966🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use...