Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35944 Views
- I also Faced
- E-Mail Answers
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
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is a cursor variable?
Why do you use stored procedures and state some of its disadvantages?
How would you begin to troubleshoot an ORA-3113 error?
How can I create database in oracle?
What are oracle functions?
How to use "for" statements in oracle?
How do I recompile a procedure in oracle?
How to use existing values in update statements using oracle?
How to install oracle database 10g xe?
List the parts of a database trigger.
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What are operators in oracle?
Give the constructs of a package, function or a procedure.
What happens to indexes if you drop a table?
