Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36471 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 the use of rows option in imp command.
How to work with data objects interactively?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What are the execution control statements?
What is ordinary table in oracle?
Why do we need oracle client?
What is merge in oracle?
Can objects of the same schema reside in different tablespace?
How to login to the server without an instance?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Is oracle an operator?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to resolve the ORA-39133 error in Oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to write a query with an inner join in oracle?
