What is the most common type of join?

0 Answers  

---

Do you know what is normalization of database? What are its benefits?

0 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

---

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

9 Answers   tdfc, vsworx,

---

What is use of except clause? How it differs from not in clause?

0 Answers  

---

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

---

which table keeps the locking information? : Sql server administration

0 Answers  

---

What is the use of floor function in sql server?

0 Answers  

---