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

Tell me what is fill factor?

907

How to find the second highest salary of an employee?

1106

What is normalization 1nf 2nf 3nf?

1003

You want to implement the one-to-one relationship while designing tables. How would you do it?

910

Do you know the cursor types?

1111

What is a scheduled job or what is a scheduled task?

911

How do I view views in sql server?

937

Do you know exporting and importing utility?

972

what is spatial nonclustered index

943

Can You Use Data Mining Models In Ssrs?

139

How to sort the query output with order by clauses in ms sql server?

983

Please differentiate between a local and a global temporary table?

949

What is a collation?

1036

What is self join in sql server joins?

961

Different types of keys in SQL?

1030