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 are the indexing methods?

1048

what is timestamp in mysql? : Sql dba

1076

Is there a way to automate sql execution from the command-line, batch job or shell script?

970

What are the subsets of sql?

1134

Determine if oracle date is on a weekend?

1041

what are date and time data types in mysql? : Sql dba

971

What is sql integrity?

1158

what is a trigger in mysql? : Sql dba

1146

What is %s in sql?

1015

What are keys in sql?

999

Is sql a dbms?

1011

How do you select unique values in sql?

997

What is a ddl command?

1087

Can a primary key be a foreign key?

1022

What is cursor explain with example?

985