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

Can primary key be null?

932

---

What do you understand by intent locks?

1012

---

What are transactions and its controls?

1061

---

What is the distinction amongst delete and truncate?

1071

---

What is the purpose of data source?

1038

---

What is sql server used for?

1049

---

What is join and name different type of joins?

1051

---

Why I have to use stored procedures?

1041

---

What are the types of normalization?

1031

---

How do I run sql server 2014?

998

---

You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?

121

---

What are the elements of dbms?

967

---

What is difference between index and primary key?

1100

---

How secure is sql server database?

1008

---

What is the difference between functions and scalar functions?

1210

---