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

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2110

How to run sql functions in pl/sql?

989

Explain the insert into statements in sql?

936

What is the difference between a subquery and a join?

1012

what are the features and advantages of object-oriented programming? : Sql dba

952

What is oracle sql developer?

992

what is 'mysqlshow'? : Sql dba

974

how to convert character strings to numeric values? : Sql dba

1024

What is $$ in sql?

940

what is the difference between union and union all? : Sql dba

974

what are numeric data types? : Sql dba

1001

What is sql used for?

1065

Does inner join return duplicate rows?

926

What are different categories of sql commands?

1068

How to add, remove, modify users using sql?

978