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 do triggers work?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

What is ssl in sql server?

0 Answers  

---

can we have a nested transaction? : Sql server database administration

0 Answers  

---

What action plan is preferred if sql server is not responding?

0 Answers  

---

What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

How self join is different from outer join?

0 Answers   Blue Star,

---

Explain transaction server isolation?

0 Answers  

---

Explain various On-Delete options in a DB table. Which is the default option?

0 Answers   Akamai Technologies,

---