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

Does a specific recovery model need to be used for a replicated database? : sql server replication

1010

---

How many triggers you can have on a table?

1032

---

What is an execution plan? How would you view the execution plan?

1129

---

Why do we backup Active Directory ?

1099

---

What is SQL Azure Fabric?

112

---

How to check if a table is being used in sql server?

1009

---

What is service broker? : sql server database administration

1029

---

What is page-level compression?

1009

---

Mention the different types of triggers?

1202

---

How can we delete a table in sql server?

1020

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1180

---

Does full backup break log chain?

1013

---

What are dml triggers and types of dml triggers?

1028

---

What are the indexes in sql server?

1186

---

Can group by be used without aggregate functions?

966

---