what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 8428 Views
- I also Faced
- E-Mail Answers
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
What are the five characteristics of good data?
How to declare and use cursor variables?
Define tool Manage Statistics in SQL Server 2000 query ?
What is a trace frag? Where do we use it?
Explain about thread and memory management process of SQL?
What are the new data types are introduced in sql 2000?
What is data source object?
How to create view in stored procedure sql server?
What is the use of tempdb? What values does it hold?
what is blocking? : Sql server database administration
What are audit control procedures?
How can change procedure in sql server?
What is a select query statement in ms sql server?
What is replication and database mirroring?
How can I track the changes or identify the latest insert-update-delete from a table?
