| |
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. |
| March 03, 2009 05:20:49 |
#3 |
| ajaysinghnegi |
Member Since: March 2009 Total Comments: 1 |
RE: HAVING vs WHERE Clause
|
1) HAVING clause can only be used to filter out the aggegate functions whereas WHERE clause cannot filter out the aggegate functions.
2) HAVING clause can be used with GROUP BY function where as WHERE clause cannot be used with group by function. |
| |
Back To Question | |
