how to delete duplicate rows in sql server 2005?

Question Posted / monty

2 Answers
4365 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

Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1

3 Answers

What language does mysql use?

0 Answers

what is the difference between gui testing and database testing? : Mysql dba

0 Answers

How do I setup mysql?

0 Answers

How internally data stores in MyISAM and INNODB table types?

0 Answers Zensar,

What are the two types of queries?

0 Answers

Why use stored procedures in mysql?