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 can I create a new template for import ? : sql server management studio

1067

Characterize join and name diverse sorts of joins?

964

Can a unique index be created on a column, which contains null?

915

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

924

what are user defined datatypes? : Sql server database administration

960

What is the purpose of sql profiler in sql server? : sql server database administration

1096

How many database files are there in sql server 2000?what are they?

1048

What are user defined functions in ms sql server?

989

Write down the syntax and an example for create, rename and delete index?

978

How to download and install microsoft .net framework version 2.0?

1133

What are different types of raid configurations? : SQL Server Architecture

1066

Can you tell me about the concept of ER diagrams?

1059

How to use column default values in insert statements in ms sql server?

1023

What are different types of data sources?

1006

How to concatenate two binary strings together?

1114