WITH T1 AS (Select *, ROW_NUMBER() OVER (PARTITION BY id Order By id) AS

how to delete duplicate rows from table

Question Posted / gayathri

Answer Posted / gayathri

WITH T1 AS (Select *, ROW_NUMBER() OVER (PARTITION BY id
Order By id) AS rowid From test)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are binary string data types in ms sql server?

1300

Name 3 ways to get an accurate count of the number of records in a table?

1040

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1067

How to bind a view to the schema of the underlying tables?

1001

Explain aggregate functions?

1086

Where is trigger in sql server?

1050

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

972

How many levels of sp nesting are possible?

1029

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

947

What does REVERT do in SQL Server 2005?

967

Define full outer join in sql server joins?

998

What is the syntax for encrypting a column in SQL Server?

1124

Do you know data definition language, data control language and data manipulation language?

1044

What is the use of floor function in sql server?

1084

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

1209