what is difference between where clause and having clause?
- 13 Answers
- 32983 Views
- I also Faced
- E-Mail Answers
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
Why is oracle so popular?
Define oracle database
Differentiate between pre-select and pre-query?
What is data file?
How to join two tables in a single query using oracle?
Explain the use of indexes option in exp command.
What is ADDM Advisor in Oracle?
What happens if variable names collide with table/column names?
How to use "if" statements on multiple conditions?
How to select some columns from a table in oracle?
What privilege is needed for a user to create indexes in oracle?
How to load a large xml file?
Explain an exception and its types?
What is an Oracle index?
What is the usage of save points in oracle database?
