What do you mean by subquery?

0 Answers  

---

What is default constraint in ms sql server?

0 Answers  

---

How to enter unicode character string literals in ms sql server?

0 Answers  

---

What are the disadvantages of merge replication?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Without Using Cursors , How to Select the Selected row??

3 Answers   CarrizalSoft Technologies, Wipro,

---

What is a user-defined function in the sql server and what is its advantage?

0 Answers  

---

What are the types of database recovery models?

0 Answers   HCL,

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

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 what is the difference between union and union all?

0 Answers  

---