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
11323 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 distinct and unique in sql?

988

Why is sql important?

1167

What does varchar include?

991

How do I get sql certification?

1015

Is left join faster than join?

1096

Can we commit inside a trigger?

1047

How do you delete duplicates in sql query using rowid?

984

how to load data files into tables with 'mysqlimport'? : Sql dba

1141

Does view store data in sql?

1035

what are the advantages a stored procedure? : Sql dba

1016

how many ways to get the current time? : Sql dba

1045

What is pl sql in dbms?

990

When is a declare statement required?

1193

What is a clob in sql?

1062

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

1006