what is difference between where clause and having clause?
- 13 Answers
- 33652 Views
- I also Faced
- E-Mail Answers
Answer Posted / sonali
1.where clause is apply on individual row ofthe table and
having is apply on group of rows in the output of select
statement.
2.having clause is used with group by clause
3.having clause is used as a final filter on the aggregate
column values in the resultset of select statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different type of segments?
How to revoke create session privilege from a user in oracle?
What are the tools for Oracle ?
What is tns entry?
How to write a query with an inner join in oracle?
What is an oracle user account?
What is the difference between PFILE and SPFILE in Oracle?
How to check the server version in oracle?
Explain an index segment?
How to retrieve data from an cursor to a record?
How to delete a column in an existing table?
What is oracle database client?
How to grant create session privilege to a user in oracle?
How to write date and time interval literals in oracle?
How to load a large xml file?
