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
A trigger can reference objects outside the current database? State true or false.
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?
What is public role in sql server?
How do I edit a procedure in sql server?
What is acid mean in sql server?
What does it mean to normalize data?
How the authentication mode can be changed?
How to apply filtering criteria at group level with the having clause in ms sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Where are full-text indexes stored?
plss anybody specify tha constrian management system in dbms
How to transfer data from a cursor to variables with a "fetch" statement?
How to convert a unicode strings to non-unicode strings?
Can you please explain the difference between primary keys and foreign keys?
Explain syntax for viewing, dropping and disabling triggers?