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,

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

How much space does sql server 2016 take?

0 Answers  

---

What are various aggregate functions that are available?

0 Answers  

---

What is the difference between createstatement and preparedstatement?

0 Answers  

---

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

What is the usage of sign function?

0 Answers  

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

0 Answers  

---

What is a sub-query? When would you use one?

3 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

How do you delete duplicate records in sql server?

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---