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 ? | 14 Yes | 8 No |
Post New Answer View All Answers
How to use "in out" parameter properly?
How to rename a tablespace in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
Explain the use of indexes option in exp command.
How to recover a dropped table in oracle?
How to pass a parameter to a cursor in oracle?
What is a cognitive schema?
What is a subquery in oracle?
What is connection pool in oracle?
How to define an oracle sub procedure?
 How to use an oracle sequence generator in a mapping?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
How to count duplicated values in a column in oracle?
Can you assign multiple query result rows to a variable?
How to convert dates to characters in oracle?