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
Do you know the capabilities of cursors?
What stored by the msdb? : sql server database administration
What is in place upgrade in sql server?
What are the differences between stored procedure and view in sql server?
Explain query editor regions
What is a field in a table?
What is a self join in sql server?
What are the system database in sql server 2008?
How to find the service pack installed? : sql server database administration
Tell me what are cursors and when they are useful?
What are the encryption mechanisms in sql server?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is difference between delete & truncate commands?
what are isolation levels? : Sql server database administration
If you want to send some data from access database to sql server database. What are different component of ssis will you use?