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 are the types of lock supported by ?

1038

---

Mention the differences between local and global temporary tables.

1023

---

What is global temp table?

989

---

Can two different columns be merged into single column? Show practically?

1057

---

what are the core components of SSRS?

129

---

Where the sql logs gets stored?

977

---

What is query optimizer in sql server?

1013

---

How to write a query with an inner join in ms sql server?

1037

---

What is an example of a foreign key?

971

---

What is change data capture (cdc) in sql server 2008?

1019

---

Explain what is the difference between a local and a global temporary table?

989

---

How to connect to a sql server using odbc_connect()?

1141

---

How to create a view on an existing table in ms sql server?

1121

---

What are “lock” hints?

1050

---

Which sql server table is used to hold the stored procedure scripts?

1056

---