with [dup_cte] as { select row_number(partition by eid order by eid) as rn

How to remove duplicate rows from a table?.

Question Posted / karthik

Answer Posted / karthik

with [dup_cte] as {
select row_number(partition by eid order by eid) as rn from emp}
go
delete from [dup_cte] where rn>1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is union?

1095

How to sort the rows in sql.

1019

Is there a 64 bit version of ssms?

909

Can we commit in trigger?

928

How to run pl sql program in mysql?

963

What are the advantages of normalization?

1042

how can we find the number of rows in a table using mysql? : Sql dba

1043

What is the process of copying data from table a to table b?

1047

What is sql clause?

1004

Where not exists in sql?

930

Does pl/sql support create command?

1056

How can you know that statistics should be updated?

1036

What is a constraint?

974

Does sqlite need a server?

1005

What does desc stand for?

1031