how to delete duplicate rows in sql server 2005?
Answers were Sorted based on User's Feedback
Answer / balaji
alter ignore table <tablename> add unique key
(field1,field2,....);
| Is This Answer Correct ? | 1 Yes | 9 No |
How do I change global variables in mysql?
Can we store pdf files in mysql?
How do I add a column to a table in mysql?
What is int unsigned?
What is the datatype of image in mysql?
What is information_schema in mysql?
What is the default port for MySQL Server?
How do I show all mysql databases?
How do I clear the screen in mysql?
How do I view data in mysql workbench?
How do you connect MySQL database with PHP?
How to show table structure mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)