what is difference between where clause and having clause?
Answer Posted / shashikant
in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )
| Is This Answer Correct ? | 44 Yes | 5 No |
Post New Answer View All Answers
Is it possible to insert comments into sql statements return in the data model editor ?
Explain the truncate in oracle?
How to create a single index for multiple columns?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is an oracle transaction?
How to create tables for odbc connection testing?
What are the different types of database objects?
What is a read write transaction in oracle?
How to convert times to characters in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
How does the on-delete-cascade statement work?
What is proxy method?
What is sharded cluster?
What are the restrictions in a oracle read only transaction?