what is difference between having and where clause ?
Answer Posted / raju
Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Do you know spatial data types - geometry and geography in sql server 2008?
How to create database with physical files specified in ms sql server?
What is recompile sql server?
how many clustered indexes can be created on a table? : Sql server database administration
What are the different index configurations a table can have?
How to use subqueries with the exists operators in ms sql server?
What is resource governor?
Tell me what is fill factor?
What is service broker? : sql server database administration
What are system databases into sql server (2005/2008) : sql server database administration
explain different types of backups avaialabe in sql server? : Sql server database administration
How to find index size for each index on table?
What are points to remember while using the fillfactor argument?
Write a sql query to display the current date?
which backup strategy you are following at ur company