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
- 9880 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
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Does full backup break log chain?
What are the diifferences between the ms sql server vs mysql?
What is the purpose of sql profiler in sql server?
How many ways to create table-valued functions?
What are some examples of schemas?
What are different types of raid configurations? : SQL Server Architecture
How to generate random numbers with the rand() function in ms sql server?
What is meant by referential integrity?
Can we store videos inside the sql server table?
How can sql server instances be hidden?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
How does index makes search faster?
Which tcl commands are available on the sql server?
How to get @@error and @@rowcount at the same time?
