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 ? | 14 Yes | 8 No |
Post New Answer View All Answers
How to invoke the data pump export utility?
What are privileges and grants?
Explain how are indexes update?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is background process in Oracle?
Can we protect our pl/sql source code?
How to invoke the data pump import utility?
How to view all columns in an existing table?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Why packages are used in oracle?
Explain enable novalidate constraint.
What is a synonym? What are its various types?
Explain what are the uses of rollback segment?
Is oracle a language?
What is a relational database management system?