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...........

What is a join in sql?

1103

---

Explain the difference between cross join and full outer join?

993

---

How to configure odbc dsn with different port numbers?

1095

---

What is report subscription?

128

---

What is database white box testing?

1133

---

What is Cross Join and in which scenario do we use Cross Join?

1020

---

What is code near application topology?

279

---

What is a benefit of using an after insert trigger over using a before insert trigger?

993

---

What is a coalesce function?

1206

---

What are “phantom rows”?

1670

---

What are orphan records?

940

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1057

---

Explain in details security in SQL azure?

121

---

Explain for xml explicit mode?

983

---

Why use update_statistics command in sql server?

1066

---