Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36529 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
Why should I use oracle database?
State any two functions of oracle?
How to sort the query output in oracle?
What exactly do quotation marks around the table name do?
What is a system tablespace?
What is analyze command used for?
What is a subquery in oracle?
What is index-organized table in Oracle?
What is the difference between substr and instr?
What is the difference between truncate & delete command?
Explain table?
What is a subquery?
What is MTTR advisor in Oracle?
Will you be able to store pictures in the database?explain.
What the is the diff between local index and global index. give some example.
