Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36329 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
How to delete a user account in oracle?
how to join query for one source type is oracle another source type is sql server ?
What do you understand by a database object? Can you list a few of them?
How to create a new user account in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain about functional dependency and its relation with table design?
Hi Can any one tell me what are the API's used in requisition import.
How to calculate date and time differences in oracle?
What is literal?
Give syntax for SQL and ORACLE joins.
Difference between pre-select and pre-query
is there a tool to trace queries, like profiler for sql server?
In what script is snap$ created? In what script is the scott/tiger schema created?
What language does oracle use?
How oracle handles dead locks?
