Answer Posted / navaneethakrishnan

Hi Kumar,

Yes it will delete only the id=1, you have to change the
id=2 whichever u want...

DELETE TOP(1) FROM [tblduplicate] WHERE [ID] = 2
DELETE TOP(1) FROM [tblduplicate] WHERE [ID] = 3

For ur kind information,.. it will delete the duplicate
records only if there is exactly 2 duplication...... if the
id 1 will entered to three times, this query will delete
only one record... because

as we enterd the query as top(1)it will select the top
most and delete the record..


This is the simple query to execute.... there is other ways
also.. to do....


Now use this query to do for more than 2 duplication

DELETE TOP(SELECT COUNT(*) -1 from dbo.tblduplicate where
id = 1)
from dbo.tblduplicate
where id = 1

How to connect ms access to sql servers through odbc?

967

---

How to use union to merge outputs from two queries together in ms sql server?

1004

---

How to get the definition of a trigger back?

954

---

What are unicode character string data types in ms sql server?

1137

---

Distinguish between nested subquery and correlated subquery?

971

---

How to manipulate data from one table to another table ?

904

---

Why transaction is important?

932

---

Explain sql server service broker?

924

---

What is failover clustering overview?

1020

---

What is difference between createstatement and preparedstatement?

1020

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

861

---

Why we use the openxml clause?

951

---

How to filter records of table in SQL SERVER?

1022

---

State a few properties of relational databases?

1060

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

950

---