what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

---

Can sql server 2016 run on windows 7?

0 Answers  

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

What is the difference between coalesce() & isnull()?

0 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,

---

What is sql view?

0 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---

Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,

---