what is difference between where clause and having clause?
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
how to join query for one source type is oracle another source type is sql server ?
How many types of tables supported by oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
how can we store any pdf file in oracle
What are the different types of trigger and explain its various uses and functions?
How to create a table index?
What are the various types of snapshots ?
Explain alias?
Can group functions be used in the order by clause in oracle?
How to synchronize 2 schema's objects?
How to get a list of all user accounts in the database?
What is the difference between a primary key & a unique key?
How to store only time; not date and time?
How to start your 10g xe server?