Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36486 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 difference between truncate and delete?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Explain what does a control file contain?
What is a trigger oracle?
How do I uninstall oracle client from windows?
What are the types of trigger in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
what is the use of system.effective.date variable in oracle?
How to invoke the data pump export utility?
List out the difference between commit, rollback, and savepoint?
What happens if you use a wrong connect identifier?
What is a data lock in oracle?
Difference between pre-select and pre-query
How can we create the complete backup of data in the oracle.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
