Collections:
Apply Filtering Criteria at Group Level in Oracle
How To Apply Filtering Criteria at Group Level in Oracle?
✍: FYIcenter.com
If you want to return only specific groups from the query, you can apply filtering criteria at the group level by using the HAVING clause inside the GROUP BY clause. The following script gives you a good HAVING example:
SQL> SELECT department_id, MIN(salary), MAX(salary), 2 AVG(salary) FROM employees GROUP BY department_id 3 HAVING AVG(salary) < 5000; DEPARTMENT_ID MIN(SALARY) MAX(SALARY) AVG(SALARY) ------------- ----------- ----------- ----------- 30 2500 11000 4150 50 2100 8200 3475.55556 10 4400 4400 4400
⇒ Count Duplicated Values in a Column in Oracle
⇐ Divide Query Output into Groups in Oracle
2019-11-21, 1879🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
What Is "mysqld" in MySQL? "mysqld" is MySQL server daemon program which runs quietly in background ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...