Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35942 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 ? | 28 Yes | 7 No |
Post New Answer View All Answers
What is blob datatype?
Explain the use of rows option in imp command.
Is truncate autocommit in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
Explain compound trigger in oracle?
Explain a private synonyms?
What is Data Dictionary Cache in Oracle?
How to pass parameters to procedures in oracle?
How to use subqueries with the exists operator in oracle?
How to get execution path reports on query statements?
How to use like conditions in oracle?
What is the difference between primary key and unique key and foreign key in oracle?
What are the original export and import utilities?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
what is dynamic SGA and static SGA
