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
what are the important architecture components of SSRS?
What is indexing and its types?
How do you rebuild an identity column?
What is temporary table in sql server? Why we use temp table?
Explain the properties of sub-query in sql server?
What is a transactions?
What is the sql case statement used for? Explain with an example?
What is dml command?
What is a database table?
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
How to view existing indexes on an given table using sys.indexes?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Explain alternate key, candidate key and composite key in sql server?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
what is the different types of backups available in sql server? : Sql server database administration