Answer Detail: RE: HAVING vs WHERE Clause

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.

August 08, 2009 12:30:24	#8
sureshmaddirala	Member Since: August 2009 Total Comments: 1
RE: HAVING vs WHERE Clause
The HAVING clause limits the grouped rows returned.

Back To Question