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 do I find the size of a sql server database?
What does indexation mean?
Define full outer join in sql server joins?
What is the ‘fillfactor’?
How to rebuild indexes with alter index ... Rebuild?
How do I view a trc file?
What are the new data types are introduced in sql 2000?
What is conditional split?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What is a trace frag? Where do we use it?
Can you pass expressions to function parameters?
What is temporal table?
Should you normalize audio?
What is an indexed view?
Explain the rules for designing files and file groups in sql server?