What is the difference between having and where clause?
Answer Posted / vinay singh
We can't use Where clause with aggregate function and Having
clause always use with aggregate function.
**Vinay Singh
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is cdc in sql server?
Do you know what are the steps to process a single select statement?
How is foreign key related to primary key?
How do use Having,Group by,Group function in SQL?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
How each E-R model constructs can be mapped to the relational model?
What is compression - row-level and page-level compression?
What are the types of ssrs?
How to resolve the orphan use problem? : sql server security
What is stored in the mssqlsystemresource database? : sql server database administration
Explain about analysis services?
What is meant by referential integrity?
What are data resources?
What is local temp table?
What is the command to change the recovery model?