| |
GeekInterview.com > Interview Questions > Oracle > SQL
| Print | |
Question: HAVING vs WHERE Clause
Answer: Where clause restricts rows, what does having clause restricts ?
1. only group results.
2. rows results.
3. both rows and groups result. |
| April 04, 2009 05:43:44 |
#5 |
| ankurlibra |
Member Since: April 2009 Total Comments: 1 |
HAVING vs WHERE Clause
|
Just like WHERE restrict rows in SELECT query, HAVING clause work only to restrict groups on group basis.
When we use HAVING clause, Oracle Server performs following steps:
(1) Rows are Grouped.
(2) The group function is applied to the group.
(3) Displays only groups that match the criteria in HAVING clause. |
| |
Back To Question | |
