how to delete duplicate rows in sql server 2005?

Question Posted / monty

2 Answers
5376 Views
EWIT, Reliance, I also Faced
E-Mail Answers

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 update a root password.

0 Answers

What is the data type for image?

0 Answers

What is 'mysqladmin' in mysql?

0 Answers

What tools available for managing mysql server?

0 Answers

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers

How to enter microseconds in sql statements?

0 Answers

Is mysql owned by oracle?

0 Answers

Why is mysql popular?

0 Answers

Is mysql a database?

0 Answers

How to enable or disable a row of a table using MySQL in struts?

0 Answers

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

0 Answers

How do you start and stop MySQL on Windows?

3 Answers

For more MySQL Interview Questions Click Here