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
10972 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

How do I view a procedure in sql?

953

what is the difference between primary key and unique key? : Sql dba

1015

What is meant by user defined function?

1027

What is the difference between subquery and correlated query?

1042

What is sql and how does it work?

1149

What is sql partition?

1082

how to convert character strings to dates? : Sql dba

1040

How do you write an inner join query?

935

Can we commit in trigger?

952

what is sub-query? : Transact sql

1081

What are the qualities of 2nf?

1022

Does sqlite need a server?

1031

What is trigger in sql? Explain

974

What are pl/sql packages?

1085

What is left join example?

932