what is difference between where clause and having clause?
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
Please explain oracle left join with an example?
How do I start tns listener?
How to do clean up if create database failed?
How to convert numbers to characters in oracle?
Explain compound trigger in oracle?
Explain constraining triggers.
Which is better Oracle or MS SQL? Why?
Can a parameter be passed to a cursor?
20. Using a set operator, display the client number of all clients who have never placed an order.
How do I recompile a procedure in oracle?
What language does oracle use?
how to do daily transactions with out sql* loader control file regesterd in apps?
What happens to the current transaction if a ddl statement is executed?
How to empty your oracle recycle bin?
What is the difference between 10g OEM and 11g OEM?