Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36308 Views
- I also Faced
- E-Mail Answers
Answer Posted / anto padma sheela
1. Having clause is usually used with Group By clause
although it can be used without it too.
2. 'Having' is just an additional filter to 'Where' clause.
3. 'Where' clause applies to the individual rows
whereas 'Having' clause is used to test some condition on
the group(usually aggregate methods) rather than on
individual rows.
| Is This Answer Correct ? | 28 Yes | 7 No |
Post New Answer View All Answers
What is recovery manager(rman) backup in Oracle?
State any two functions of oracle?
How data locks are respected in oracle?
What are the data types in oracle?
What is meant by raw datatype?
How do I connect to oracle?
What is redo log?
definition of cluster and non-clustered index?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Explain the blob datatype?
How to create a table in a specific tablespace?
Can a formula column referred to columns in higher group ?
How do I manually uninstall oracle client?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
