what is the difference between group and having
give an example with query and sample output
Answer Posted / pawan378
in addition to the above correct answers ..
Having Clause allows to add conditions using functions
Ex: COUNT(*) > 2
at on the same phrase of the query. this will be basically
to avoid sub queries.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are sparse columns?
How to connect Azure federated root database and apply federation in entity framework?
What is the default schema of your login session in ms sql server?
What happens if the update subquery returns multiple rows in ms sql server?
What is the difference between online clustering and Offline clustering?
How to specify the collation for a character data type in ms sql server?
when you create a database how is it stored? : Sql server database administration
Explain what is public role in sql server?
What is a natural primary key?
Explain try...catch with sql server?
what is the system function to get current user's user id? : Sql server database administration
Is there any difference between the primary key and unique key?
What is the temp table?
Tell about MOM Tool(Microsoft Operator Manager)?
What are the types of dml?