What is the difference between a HAVING CLAUSE and a WHERE
CLAUSE?
Answer Posted / guest
Having Clause is basically used only with the GROUP BY
function in a query. WHERE Clause is applied to each row
before they are part of the GROUP BY function in a query.
| Is This Answer Correct ? | 68 Yes | 4 No |
Post New Answer View All Answers
what is nonclustered index
What is SubQuery in SQL Server 2008
what are different types of backups available in sql server? : Sql server database administration
What is the security model used in sql server 2005?
Explain about system stored procedure?
what is a join and explain different types of joins? : Sql server database administration
Where views are stored in sql server?
Explain the database you used in your final year project?
What are the differences between decimal and float in ms sql server?
Explain multiserver query
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What is dynamic cursor in SQL SERVER?
What are the advantages of the mirroring?
What is intellisense?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration