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 ......
2019-10-27, 897👍, 0💬
Popular Posts:
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...