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
23352 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 dynamic sql in pl sql?

1000

What are aggregate functions in sql?

1111

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1098

What are the most important ddl statements in sql?

1051

What is record type in pl sql?

954

what are the different tables present in mysql? : Sql dba

937

Can cursors be part of a trigger body?

1599

Why we use sql profiler?

927

what are sequences

1675

Which constraints we can use while creating database in sql?

1035

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3957

Can we use join in subquery?

1046

What are actual parameters and formal parameters?

1054

Can you call pl/sql package functions from within a fast formula?

992

What is serial sql?

937