When to use Inner join & when to use subquery?

0 Answers   IBM,

---

What is Self Join?

4 Answers  

---

Why do you want to join software field as you have done your BE in Electronics?

0 Answers   Cap Gemini, HCL,

---

What is the contrast between sql and pl/sql?

0 Answers  

---

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

How do I view a script in sql server?

0 Answers  

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---

Find nth lowest salary or get nth lowest salary?

0 Answers  

---

Explain what is the function of sql server agent windows service?

0 Answers  

---

What is create statement?

0 Answers  

---

Why is sql server log file full?

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---