We can delete duplicate rows from table by using distinct command.

how to delete duplicate rows from table in sql server

Question Posted / swapna

Answer Posted / swapna

We can delete duplicate rows from table by using distinct
command.

Is This Answer Correct ?

10 Yes

35 No

Please Help Members By Posting Answers For Below Questions

if no size is defined while creating the database, what size will the database have? : Sql server administration

973

What is cross join in sql server joins?

1116

Will sql server 2005 allow you to reduce the size of a column?

966

What is the ‘fillfactor’?

950

How can I create a report based on a query? : sql server management studio

997

What is service broker? : sql server database administration

973

In how many ways you can invoke ssrs reports?

137

What is Extended user-defined?

942

Define Unique Key?

984

Why is sql server log file full?

1016

What is the stored procedure?

985

What is the purpose of a table?

944

How to create a large table with random data for index testing in ms sql server?

1011

Ways to improve the performance of a SQL Azure Database?

125

How to list all objects in a given schema?

1035