Collections:
Use Multiple Columns in GROUP BY in Oracle
Can Multiple Columns Be Used in GROUP BY in Oracle?
✍: FYIcenter.com
You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department:
SQL> SELECT department_id, salary, count(*) 2 FROM employees GROUP BY department_id, 3 salary HAVING count(*) > 1; DEPARTMENT_ID SALARY COUNT(*) ------------- ---------- ---------- 90 17000 2 50 3200 4 50 2200 2 50 3600 2 80 10500 2 80 9000 2 50 2700 2 ......
⇒ Use Group Functions in ORDER BY Clause in Oracle
⇐ Count Duplicated Values in a Column in Oracle
2019-10-27, 1745🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...