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
11089 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 are types of indexes in sql?

1084

Is primary key an index?

998

what is the difference difference between procedure and packages

10419

What is view? Can we update view

1447

What is input buffer in sql*plus?

1232

how to rename an existing column in a table? : Sql dba

1023

What is a recursive stored procedure?

1188

What do you mean by “trigger” in sql?

1086

What is the cause of mutating table error and how can we solve it?

1054

what is bcp? When does it used? : Sql dba

995

What are dml commands?

1026

What is rollback?

1118

Can we rollback truncate?

1004

What is ttitle and btitle?

1069

Why do we need view in sql?

991