Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between where clause and having clause?
- 13 Answers
- 36481 Views
- I also Faced
- E-Mail Answers
Answer Posted / anant chavda
Þ The WHERE clause excludes rows that do not meet its
search conditions
Þ The GROUP BY clause collects rows that met the WHERE
clause search conditions and places those rows into a group
for each unique value in the GROUP BY clause. Omitting the
GROUP BY clause creates a single group for the whole table.
Þ The HAVING clause excludes groups that do not meet
its conditions. For example: When a query includes a GROUP
BY clause, the HAVING clause excludes groups from the
results. A SELECT statement containing a HAVING clause
without a GROUP BY clause will process the result as one
whole set. Aggregate functions specified in the select_list
calculate summary values for each surviving group.
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is the usage of save points in oracle database?
How to best split csv strings in oracle 9i?
How to define an external table with a text file?
What is a nvl function?
Explain overloading. Can functions be overloaded?
How to run create database statement again?
How to apply filtering criteria at group level in oracle?
What is a system tablespace and when it is created?
Can you tell me how to add new column in existing views?how?How is possible?
Describe an oracle table?
Why is oracle so popular?
How to upsert (update or insert into a table)?
Explain the use of record option in exp command.
Is postgres faster than oracle?
How to rebuild an index in oracle?
