what is difference between where clause and having clause?
- 13 Answers
- 32917 Views
- I also Faced
- E-Mail Answers
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
How to pass a parameter to a cursor in oracle?
What is ordinary table in oracle?
What happens in oracle commit?
What is tns service name?
How do I manually uninstall oracle client?
How to change system global area (sga) in oracle?
Please explain joins in oracle?
What is oracle sid?
How to define a data source name (dsn) in odbc manager?
How to execute the package in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
 How to use an oracle sequence generator in a mapping?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a trigger oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
