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.

July 07, 2009 08:17:17	#7
rajiv_datasoft	Member Since: July 2009 Total Comments: 3
RE: HAVING vs WHERE Clause
HAVING clause restricts the group function where as WHERE clause restricts the rows that is returned by query.

Back To Question