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  

---

Explain cross join or cartesian product in sql?

0 Answers  

---

Explain what is analysis service repository?

0 Answers  

---

how to replace double quotes by single quotes in sql server

2 Answers   CAC,

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

What are diverse clauses that form a part of sql?

0 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

What is indexed view?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

---

between cast and convert which function would you prefer and why?

0 Answers  

---