what is difference between where clause and having clause?

Answer Posted / narender sharma

Where clause is used to restrict rows but having clause is
used to restrict groups

Is This Answer Correct ?    28 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sharded cluster?

611


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1856


What is index-organized table in Oracle?

657


What are the differences between interval year to month and interval day to second?

639


What are data pump export and import modes?

715






WHAT IS ecc 6.0

1765


How to load a large xml file?

683


Is there an oracle sql query that aggregates multiple rows into one row?

626


What is a trigger and what are its types?

689


Explain the types of exception?

735


What is the simplest tool to run commands on oracle servers?

596


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1610


Design database draw er diagram for a certain scenario ?

4184


What do database buffers contain?

654


What is raw datatype?

671