Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 35938 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
Explain what are the type of synonyms?
What is difference between truncate and delete?
How to define an explicit cursor in oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
What is hash cluster in oracle?
How do you bind variables in oracle?
How to export several tables together?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is coalesce function?
What is Java Pool in Oracle?
What is an oracle function?
How to rename an existing table?
How to connect asp pages to oracle servers?
What is the max number of columns in an oracle table?
What do you mean by merge in oracle?
