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
When you should use a low fill factor?
define and explain the differences between clustered and non-clustered indexes.
What are horizontal and vertical scaling?
How can we improve performance by using SQL Server profiler?
What is user-defined multi-statement table-valued function?
What are the different types of data sources in ssrs?
Explain the third normal form(3nf)?
how to trace the traffic hitting a sql server? : Sql server database administration
What is the difference between varchar and nvarchar datatypes?
How to modify the underlying query of an existing view?
What happens when converting big values to numeric data types?
What is a data source or ds? : sql server analysis services, ssas
Explain about merge replications?
How to filter out duplications in the returning rows in ms sql server?
Tell me something about security and sql azure?