what is difference between where clause and having clause?
- 13 Answers
- 32982 Views
- I also Faced
- E-Mail Answers
Answer Posted / arkchowdary
Where Clause------------------ It is used to Filter Rows
(i.e Restrict Rows and It appiles to the Individual Rows).
Having Clause----------------- It appies on Groups (i.e
Aggregate Functions).
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What is blob data type in oracle?
What is data file?
What is the data pump import utility?
List out the components of logical database structure of oracle database.
Explain how you would restore a database using RMAN to Point in Time?
Can we convert a date to char in oracle and if so, what would be the syntax?
Query to retrieve record for a many to many relationship ?
What are set operators?
Explain enable novalidate constraint.
what are actual and formal parameters?
What is hash cluster in oracle?
How to use like conditions in oracle?
How to use in conditions in oracle?
What is the exact use of Collections?
What is ordinary table in oracle?
