Discussion in 'General DBA Questions' started by sramesh, Mar 3, 2006.
any body clear my doubt
Diffrence between a "where" clause and a "having" clause
HAVING is like WHERE, but it's applied to the groups of a GROUP BY.
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstÃ¯Â¿Â½tze PASS Deutschland e.V. http://www.sqlpass.de)
You can compare column values in Where and aggregate values in Having
Select columns from yourTable
group by columns
Failing to plan is Planning to fail
Separate names with a comma.