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
What is the difference between a local and a global temporary table?
what does the automatic recovery do? : Sql server administration
What is difference between Datepart() and Datename() in SqlServer?
What stored by the msdb? : sql server database administration
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How many types of local tables are there in sql server?
Can we use where and having clause together?
What is DCL?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Does full backup break log chain?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Can sql servers link to other servers like oracle?
What are the benefits and tasks of object explorer? : sql server management studio
What is a trigger in sql server?
In which files does sql server actually store data?