what is difference between where clause and having clause?
Answer Posted / anto padma sheela
1. Having clause is usually used with Group By clause
although it can be used without it too.
2. 'Having' is just an additional filter to 'Where' clause.
3. 'Where' clause applies to the individual rows
whereas 'Having' clause is used to test some condition on
the group(usually aggregate methods) rather than on
individual rows.
Is This Answer Correct ? | 28 Yes | 7 No |
Post New Answer View All Answers
How to use fetch statement in a loop?
How to add a new column to an existing table in oracle?
Explain self joins in oracle?
What is a nested table?
How do I find my oracle client driver version?
What is the implicit cursor in oracle?
How to export data to a csv file?
What happens to the current transaction if the session is killed?
Can sub procedure/function be called recursively?
How to insert multiple rows with one insert statement in oracle?
Why cursor variables are easier to use than cursors?
Explain a segment?
How to delete multiple rows from a table in oracle?
How many types of tables supported by oracle?
How to declare a local variable?