what is difference between having and where clause ?
Answer Posted / dhiman
Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to find the service pack installed? : sql server database administration
What is change tracking in sql server?
What are user defined functions in ms sql server?
What is the difference between left and right outer join?
Which is the latest version of sql server and when it is released?
what are the core components of SSRS?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
Can you roll back the ddl statement in a trigger?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
what is memory-optimized nonclustered indexes
How to access the deleted record of an event?
query processing
what is denormalization and when would you go for it? : Sql server database administration
What is update_statistics command?
Explain the architecture of ms sql reporting service?