| |
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. |
| November 11, 2008 08:37:33 |
#2 |
| Preeti Ajjampur |
Member Since: November 2008 Total Comments: 1 |
RE: HAVING vs WHERE Clause
|
| There can be as many columns as the table have but the columns in the SELECT list that are not in the group function must be in the group by clause and its not compulsory that the column in the group by must be in the select |
| |
Back To Question | |
