Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36910 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
Write a trigger example in oracle?
How many file formats are supported to export data?
How to create id with auto_increment on oracle?
How to pass a cursor variable to a procedure?
Can objects of the same schema reside in different tablespace?
What is tns entry?
query optmization techniques and quwry analyser+projects+ppts
What are the numeric comparison operations?
What is the difference between PFILE and SPFILE in Oracle?
How to convert raw data type into text in oracle? Explain
What are the execution control statements in oracle?
Explain oracle 12c new features for developers?
What is hot backup and logical backup?
What is the max number of columns in an oracle table?
What is the relation of a user account and a schema?
