write sub query for eliminating duplicate rows using analytical function?

write sub query for eliminating duplicate rows using
analytical function?

Question Posted / devi

3 Answers
11730 Views
Metric Stream, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write sub query for eliminating duplicate rows using analytical function?..

Answer / korimantu

delete from table name where rowid not in(select max(rowid)
from group by last_name);

or

delete from table name where rowid>(select min(rowid) from
where a.last_name=b.last_name);

Is This Answer Correct ?

4 Yes

2 No

write sub query for eliminating duplicate rows using analytical function?..

Answer / vyshak

delete from table where rowid not in (select max(rowid) from
table group by all column names);

or

delete (dense_rank() over(partition by all column names))dn
from table where dn>2;

Is This Answer Correct ?

4 Yes

3 No

write sub query for eliminating duplicate rows using analytical function?..

Answer / guest

select distinct

Is This Answer Correct ?

1 Yes

1 No

Post New Answer