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

What is sql query limit?

975

Can we join same table in sql?

1016

Show code of a cursor for loop.

1052

What are conditional predicates?

1057

what is index? : Sql dba

1003

Explain what is a view?

1057

How does one load ebcdic data? : aql loader

1167

What are primary key and foreign key and how they work?

973

what is blob? : Sql dba

1144

What is cross join example?

990

Write a sql query to find the names of employees that begin with ‘a’?

1011

can sql servers linked to other servers like oracle? : Sql dba

1005

What does the hierarchical profiler does?

1057

difference between anonymous blocks and sub-programs.

1133

How do you rank data in sql?

1000