Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36907 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
When do you get a .pll extension in oracle? Explain its importance
what are archived logs?
What is clustered table in Oracle?
What is the difference between a hot backup and a cold backup in oracle?
How do we get field detail of a table?
What is a snapshot in oracle database?
How to invoke the original export import utilities?
What is SQL Tuning Advisor in Oracle?
How are extents allocated to a segment?
What is an oracle cursor variable?
What is a view and how is it different from a table?
What are the system predefined user roles?
How can we find out the current date and time in oracle?
What is dual table oracle?
What privilege is needed for a user to delete rows from tables in another schema?
