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 is the default fill factor value?

1127

What is the difference between a fill factor of 100 and 0?

1029

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

1122

Can foreign key be deleted?

979

Introduction of rollup clause using sum and group by clause?

1011

Sql server reporting services vs. Crystal reports.

140

Which sql server table is used to hold the stored procedure scripts?

1110

Explain what is log shipping?

1192

can you implement data mining in SSRS?

157

Why I am getting this error when dropping a database in ms sql server?

1119

What is table join?

1172

What are the filtered indexes?

1093

Indexes are updated automatically is the full-text index also updated automatically?

1065

What are indexes in ms sql server?

1115

Tell about MOM Tool(Microsoft Operator Manager)?

1959