| |
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 21:16:55 |
#4 |
| gfreilly |
Member Since: March 2007 Total Comments: 1 |
RE: HAVING vs WHERE Clause
|
| Logic behind a having clause is only related to results of group functions as opposed to the logic of a where clause which relates to columns or expressions for individaul rows. |
| |
Back To Question | |
