what is the difference between group and having
give an example with query and sample output
Answer Posted / soorai ganesh
create table lovepair (boyfrndname varchar(10),girlfrndname
varchar(10))
insert into lovepair values ('BF1','GF1')
insert into lovepair values ('BF1','GF2')
insert into lovepair values ('BF1','GF3')
insert into lovepair values ('BF2','GF1')
insert into lovepair values ('BF2','GF2')
insert into lovepair values ('BF3','GF3')
insert into lovepair values ('BF3','GF3')
insert into lovepair values ('BF3','GF3')
-- Here BF1 have 3 Girl Friends. like the BF2 and BF3 have
2 and 3 Girl Friends Simultaneously.
-- Here is the query for, how many girls friends each boys
have ???? USING group by
SELECT boyfrndname, COUNT (*)
FROM lovepair
GROUP BY boyfrndname
// Here another qry for who have more than 2 girl
friends ?? USING GroupBy and Having .
// Having is used for applying some condition in Aggregate
function
SELECT boyfrndname,COUNT(*)
FROM lovepair
Group BY boyfrndname
having count(*)>2
--- Now u clear...........
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the difference between upgrade and migration in sql server?
What is difference between after and before?
Give an example of SQL injection attack ?
What is sql stored procedure?
What are the different SQL Server Versions you have worked on?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are the restrictions while creating batches in sql server?
How to turn off warning messages during php execution?
Explain nested trigger in sql?
How many types of local tables are there in sql server?
What does select 1 mean?
How do I find the sql server database version?
What is the default fill factor value?
How do you size a resultset?
How use inner join in sql server?