Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

Explain some DBCC commands?

6 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---

Define full outer join in sql server joins?

0 Answers  

---

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

How to create user defined functions with parameters?

0 Answers  

---

What objects does the fn_my_permissions function reports on? : sql server security

0 Answers  

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

What is a non-clustered index?

0 Answers  

---