Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36480 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
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is oracle host variable?
How would you change old and new values in an insert, delete and update triggers?
State the difference between a primary key and foreign key?
What are the differences between date and timestamp in oracle?
How to create a new tablespace in oracle?
What is difference between sid and service name in oracle?
How to rebuild an index in oracle?
How to pass a cursor variable to a procedure?
What is a trigger and what are its types?
Why is oracle used?
What is a snapshot log?
what happened to the global index when I truncate the data in one of the partition?
Which is better Oracle or MS SQL? Why?
Is there any function in oracle similar like group_concat of mysql?
