DELETE FROM Emp A WHERE ROWID NOT IN &

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 / swastik

9 Answers
11031 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / swastik

DELETE FROM Emp A
WHERE ROWID NOT IN
(
SELECT MIN(ROWID)
FROM Emp B
WHERE A.Sal = B.Sal
)

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you change a value in sql?

1006

Is keyword pl sql?

975

How do I count records in sql?

987

Does truncate table reset auto increment?

984

What does varchar include?

942

What is trigger in sql?

1083

What is coalesce in sql?

1048

what is text? : Sql dba

1065

What is example of database?

1049

How do I run a pl sql program?

1121

How does cross join work in sql?

1007

What are inner outer left and right joins in sql?

1006

Explain the the update statement in sql?

1027

What is the difference between a primary key and a unique key?

1050

Is pl sql still used?

970