what is the difference between group and having
give an example with query and sample output
Answer Posted / dinesh sharma
Group by is used To Group Result According To Group Name
Having Is Always Is Used With Group by Clause.
Having Contain Aggregate Function or Simple Sub Query .
as Show In Above Example
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How much does sql server 2016 cost?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is code near application topology?
Why use triggers?
How do I connect to sql server database?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is after dml trigger?
How many types of subqueries are there in sql server?
What is difference between primary key and foreign key?
Explain security with sql azure?
What is trigger explain with program?
Explain different types of collation sensitivity?
What is the security principal at the database level that represents your session?
Is it possible to call a stored procedure within a stored procedure?
What is executereader?