WithoutBook Forum
Ques. how to delete duplicate rows from a table ?
- how to delete duplicate rows from a table ?
Posted on Sep 14, 2012 by Supriya
Ans. Is applet have constructor? and why we not use main in applet program?
Posted on Sep 14, 2012 by Supriya
Ans. Please try to execute the following query by modifying as per your table and columns:
select * from tbl;
with a as
(
select row_number() over(partition by col1 order by col2, col3, colX) as rn
from tbl
)
delete from a where rn > 1;
select * from tbl;
select * from tbl;
with a as
(
select row_number() over(partition by col1 order by col2, col3, colX) as rn
from tbl
)
delete from a where rn > 1;
select * from tbl;
Posted on Nov 06, 2012 by Arindam