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


Please Help Members By Posting Answers For Below Questions

A trigger can reference objects outside the current database? State true or false.

532


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

481


What is public role in sql server?

512


How do I edit a procedure in sql server?

518


What is acid mean in sql server?

546






What does it mean to normalize data?

493


How the authentication mode can be changed?

577


How to apply filtering criteria at group level with the having clause in ms sql server?

532


What are the rules to use the rowguidcol property to define a globally unique identifier column?

570


Where are full-text indexes stored?

548


plss anybody specify tha constrian management system in dbms

1534


How to transfer data from a cursor to variables with a "fetch" statement?

565


How to convert a unicode strings to non-unicode strings?

534


Can you please explain the difference between primary keys and foreign keys?

631


Explain syntax for viewing, dropping and disabling triggers?

481