select n from (select row_number()over (partition by n order by n) r,n fro

one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000

So my requirement is i want output like
SAL
---
1000
2000
3000

it mean i want to delete duplicate rows only how should u
write query?

Question Posted / hiya

9 Answers
10715 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / hiya

select n from (select row_number()over (partition by n order
by n) r,n from test group by n having count(*)>1)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between a database and a relational database?

1032

Can we join same table in sql?

958

What is left join example?

886

Is oracle sql free?

926

Can we call a function containing dml statements in a select query?

916

define data blocks ? : Sql dba

923

What is the difference between left join and right join?

887

what are the limitations of identity column? : Transact sql

1043

Is left join inner or outer?

961

Why does sql need a server?

986

how is exception handling handled in mysql? : Sql dba

1006

Write the alter statement to enable all the triggers on the t.students table.

1066

How do I run sql?

1092

What does over partition by mean in sql?

919

What is pl sql in oracle?

988