What is the difference between HAVING clause and the WHERE
clause?
Answer Posted / vivek kumar
where clause is used for conditional retriving but having
clause is used to test some condition on the group with the
help of aggregate function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is set nocount on and what is set nocount off?
What are logical/boolean operations in ms sql server?
Can you explain what is the use of custom fields in report?
How to download microsoft sql server 2005 express edition?
What is database mirroring?
What is repeatable read?
Explain various data region available in ssrs with their use?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Is ssrs support other database except ms sql server?
What is difference between getdate and sysdatetime in sql server 2008?
Which database stores information about replication?
What are different types of subquery?
List some major differences between triggers and stored procedures?
Explain the different types of joins?
Do you know how to implement service broker?