Sign Up Login


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

how to delete duplicate rows in sql server 2005?

Question Posted / monty

Answers were Sorted based on User's Feedback



how to delete duplicate rows in sql server 2005?..

Answer / shashikant

distinct <column name>
from <table name>

Is This Answer Correct ?    3 Yes 2 No

how to delete duplicate rows in sql server 2005?..

Answer / balaji

alter ignore table <tablename> add unique key
(field1,field2,....);

Is This Answer Correct ?    1 Yes 9 No

Post New Answer

More MySQL Interview Questions

What is DML in MySQL?

1 Answers  

How can I see connections in mysql?

0 Answers  

Give the syntax of Grant and Revoke commands?

1 Answers  

What is mysql port?

0 Answers  

What are HEAP tables in MySQL?

1 Answers  

What is limit in mysql?

0 Answers  

Why do we use views instead of tables?

0 Answers  

Does uninstalling mysql delete database?

0 Answers  

Which is faster mysql or mongodb?

0 Answers  

How to drop an existing view in mysql?

0 Answers  

What is slow query log in mysql?

0 Answers  

Why phpmyadmin is used for mysql?

0 Answers  

For more MySQL Interview Questions Click Here
Categories