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 check the server version in oracle?
What do database buffers contain?
How to write a query with an inner join in oracle?
Is primary key indexed by default in oracle?
What is rich query?
What is recycle bin in Oracle?
How to invoke the data pump import utility?
How many types of tables supported by oracle?
How to resolve name conflicts between variables and columns?
What are the predefined tablespaces in a database?
Explain the blob datatype?
What is an Oracle index?
How to create a table in a specific tablespace?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to assign a tablespace to a users in oracle?