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

Name few endpoints exposed by ssrs 2012?

355

What are approximate numeric data types in ms sql server?

1045

What is the temp table?

910

What is the purpose of a table?

957

Which are the third-party tools used in sql server and why would you use them?

892

How do I delete a sql server database?

1034

How to use transact-sql statements to access the database engine?

1050

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

888

How do you rebuild an identity column?

941

What is sql sandbox in sql server?

1208

How to execute stored procedure and set temp table in sql server?

1028

Can you name some of the dml commands in sql?

1015

Do you know query execution plan?

1158

What is data modeling and Reterminal integrity?

1951

Explain the cursor lock types?

1041