Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36328 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 ? | 14 Yes | 8 No |
Post New Answer View All Answers
Where is the export dump file located?
What are the system predefined user roles?
How to write a left outer join with the where clause in oracle?
Why do you create or replace procedures rather that drop and recreate.
What the is the diff between local index and global index. give some example.
How to Truncate Table in Oracle
what is the difference between restoring and recovering?
How to store pictures on to the database?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Explain oracle left join with an example?
How to create a stored procedure in oracle?
What is the sql query to concatenate column values from multiple rows in oracle?
How to install oracle odbc drivers?
When system tablespace is created?
How do I know if oracle client is installed on windows?
