Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76380 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / sujit kumar suman,new delhi
DELETE DUPLICATE RECORDS FROM TABLE IN SQL SERVER:
DELETE FROM TABLE1
WHERE
ID NOT IN
(SELECT MAX(ID) FROM TABLE1
GROUP BY NAME)
WHERE ID IS IDENTITY FIELD AND NAME IS DUPLICATE FIELD
TRY THIS QUERRY AND ENJOY.......
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What language is sql server written in?
Explain syntax for viewing trigger?
What to perform pattern match with the like operator?
Differentiate sql server reporting services vs. Crystal reports?
What is built-in/administrator?
How to list all field names in the result set using mssql_field_name()?
how you can move data or databases between servers and databases in sql server? : Sql server administration
What is query parameter in ssrs?
How do I find my localdb version?
What are secondary xml indexes?
How you can change a cross join into an inner join?
Explain about Normalization?
Explain the properties of the relational tables?
How to stop log file growing too big?
What's the information that can be stored inside a bit column?
