How to insert multiple rows with a subquery?

0 Answers  

---

What are the dmvs?

0 Answers  

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---

Write query to return all rows sql?

0 Answers  

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

List the advantages of using stored procedures?

0 Answers  

---

Why truncate is ddl command?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

Explain sub-query?

0 Answers  

---

What is the difference between functions and scalar functions?

0 Answers   EXL,

---