select salary from emp where rowid NOT IN(select max(rowid) from emp GROUP

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 in the table
permanently and i want output in the above formatow should u
write query?

Question Posted / yaswanth

13 Answers
23710 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

Answer Posted / yaswanth

select salary from emp where rowid NOT IN(select max(rowid) from emp GROUP BY salary);

Is This Answer Correct ?

14 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

How do I create an index in word?

1034

What is sql injection vulnerability?

944

What is dense_rank?

935

How can we find duplicate records in a table?

948

How do you rank data in sql?

1005

What does a pl/sql package consist of?

976

what is a composite key ? : Sql dba

1062

What is the purpose of cursors in pl/sql?

1136

Is sql free?

970

what is an index? : Sql dba

997

How do I remove sql plus from windows 10?

1101

What is a recursive join sql?

1076

How many triggers can be applied on a table?

935

Which is faster view or stored procedure?

946