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  

---

What is the difference between count () and rowcount ()?

0 Answers  

---

What are the different types of replication? How are they used?

3 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

How many types of objects are there?

0 Answers  

---

---

How to swap the data of two columns in a table. both the columns containing varchar values.

9 Answers  

---

what is an extended stored procedure? : Sql server database administration

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

Do you know what are acid properties?

0 Answers  

---

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---