what is difference between where clause and having clause?

Answer Posted / manvendra

RISTRICT GROUP BY FUNCTION BY HAVING.
RESTRICT NORMAL QUERY BY WHERE.

YOU CAN PUT WHERE AND HAVING IN A QUERY.

Is This Answer Correct ?    14 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe an oracle table?

578


How to get a list of all background sessions in the database?

544


What are the tools for Oracle ?

613


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?

1533


Why do we need integrity constraints in a database?

592






HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1793


What is an oracle?

583


How do I call oracle stored procedures that take no parameters?

572


What are the attributes of cursor?

593


How to loop through data rows in the implicit cursor?

547


What is the difference between view and materialized view in Oracle?

616


What are the differences between char and nchar in oracle?

603


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1762


What is a partition in oracle?

549


What is oracle used for?

539