How to apply filtering criteria at group level in oracle?
- 1 Answers
- 1128 Views
- I also Faced
- E-Mail Answers
Answer Posted / Priyanka Suman
To apply filtering criteria at group level in Oracle, you can use the HAVING clause after the GROUP BY clause. The HAVING clause filters groups based on an aggregate condition. For example:nn```sqlnSELECT department_id, COUNT(employee_id) as number_of_employeesnFROM employeesnGROUP BY department_idnHAVING department_id = 90;n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
Design database draw er diagram for a certain scenario ?
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
