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
How do you create an execution plan?
What is instead of dml trigger?
What is the use of keyword with encryption.
Difference between Inner vs outer joins?
How to concatenate two strings in SQL Server.
Explain what are the different index configurations a table can have?
Which language rdl files made of?
what are constraints? Explain different types of constraints? : Sql server database administration
What is the stored procedure?
Do you know what is a trace frag? Where do we use it?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How to list all objects in a given schema?
What is the recovery model?
What are distributed partitioned views?
Difference between Logical Page and Physical Page in SSRS.