What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / swati mandve
where clause is executed (for each row) first and
written before the group by statement..
having clause is strictly folllowed by groupby clause.to
filter the group.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain isolation levels that sql server supports?
Explain forward - only cursors?
Issues related in upgrading SQL Server 2000 to 2005 / 2008
Why use “pivot” in sql server?
Define Unique Key?
What is the default value of an integer data type in sql server 2005?
What are the different ways you can create databases in sql server?
What are indexes in sql?
Why do we need normalization?
What are the database objects? : SQL Server Architecture
What is the difference between an index and a unique index?
What are user-defined functions (udfs) in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Can I save my report as html, excel or word? : sql server management studio
How to provide values to stored procedure parameters in ms sql server?