what is difference between where clause and having clause?
- 13 Answers
- 33018 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
How to create an oracle database manually?
How to store only time; not date and time?
What is the data pump import utility?
What is a nvl function? How can it be used?
What is ADDM Advisor in Oracle?
List the various oracle database objects?
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.
How data locks are respected in oracle?
What is data block in Oracle?
Explain about the analyze command in oracle?
How to set a transaction to be read only in oracle?
Explain the use of log option in exp command.
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is sequence?
How oracle handles dead locks?
