if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

Explain the properties of subqueries in sql server?

0 Answers  

---

What is after dml trigger?

0 Answers  

---

Can we join two tables without primary key?

0 Answers  

---

how you can list all the tables in a database?

0 Answers  

---

---

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

---

Difference between group by clause and having clause in SQL?

0 Answers   Flextronics,

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

‘Order by’ is not allowed in a view how can you sort information from a view?

0 Answers  

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How can you check the version of sql server?

0 Answers  

---

How to rename databases in ms sql server?

0 Answers  

---