Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between group and having
give an example with query and sample output
- 7 Answers
- 9852 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 is an example of a primary key?
What do you mean by collation recursive stored procedure?
Can we check locks in database? If so, how can we do this lock check?
What is policy based management (pbm)? : sql server database administration
Some queries related to SQL
What the different topologies in which replication can be configured?
Why do we use non clustered index?
Can you please explain the difference between function and stored procedure?
What are system databases into sql server (2005/2008) : sql server database administration
Explain the cursor lock types?
Can sql servers linked to other servers like oracle?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is the difference between value type and reference type?
Do you know what is difference between stored procedure and user defined function?
Explain some stored procedure creating best practices or guidelines?
