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

How to increment dates by 1 in mysql?

0 Answers  

Explain the different types of constraints?

0 Answers  

What is MySQL?

0 Answers  

how to connect a php script with the mysql database?

0 Answers  

What is view in mysql?

0 Answers  




What is the data source name for mysql?

0 Answers  

What are the advantages and disadvantages of MySQL?

0 Answers   Satyam,

Is mysql free software?

0 Answers  

What are the benefits of mysql?

0 Answers  

How do I find the size of a mysql database?

0 Answers  

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

0 Answers  

Explain the architecture models of SQL Server?

0 Answers  

For more MySQL Interview Questions Click Here
Categories