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

How to define output parameters in stored procedures?

1027

How to list all field names in the result set using mssql_field_name()?

914

What is join query?

893

What is executereader?

952

What is the difference between functions and stored procedures?

1161

Define synonym?

1173

What is an expensive query?

931

How to update multiple rows with one update statement in ms sql server?

1203

Explain the properties of a relational table?

1024

How to insert data with null values?

1025

what stored procedure would you use to view lock information? : Sql server administration

971

What is store procedure? How do they work?

1020

Explain error handling in ssis?

1023

What is normalization according to you and explain its different levels?

949

What is single-user mode?

940