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 are temporal data types in oracle?

602


What is the dynamic sql in oracle?

603


How to start a specific oracle instance?

584


What are the predefined tablespaces in a database?

556


How to change system global area (sga) in oracle?

573






if you ctreate table identity

1849


How to grant create session privilege to a user in oracle?

574


Explain the features of oracle?

602


Explain the use of indexes option in imp command.

568


How to use "in" parameter properly?

621


How to end the current transaction in oracle?

562


Explain what are the uses of rollback segment?

590


What is control file used for?

607


Explain the use of record length option in exp command.

562


What is the difference between online and offline backups?

565