Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

What is the purpose of self join?

0 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

What types of Joins are possible with Sql Server?

0 Answers   NA,

---

Write the syntax for stuff function in an sql server?

0 Answers  

---

Can primary key be null?

0 Answers  

---

What is field in algebra?

0 Answers  

---

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

---

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

---