Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 Answers  

---

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

0 Answers  

---

When you first load SQL SERVER you will startup with what all databases?

3 Answers   CompuSol,

---

What is a with(nolock)?

0 Answers  

---

---

What is mssql?

0 Answers  

---

What are different types of join?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

how you can list all the tables in a database?

0 Answers  

---

How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

syntex of insert

7 Answers  

---