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

explain commit and rollback in mysql : sql dba

1070

What is union, minus and interact commands?

1361

What is sql catalog?

1067

Inline the values in PL/SQL, what does it mean.?

1273

What is error ora-01000: maximum open cursors exceeded

1205

Is there a 64 bit version of ssms?

997

What is the difference between a subquery and a join?

1169

In pl/sql, what is bulk binding, and when/how would it help performance?

1030

What is a dynamic query?

1069

Can %notfound return null after a fetch?

1101

What is cursor and why it is required?

1251

Difference between table function and pipelined function?

1078

What is replication id?

987

what is a database transaction? : Sql dba

1255

How do I remove sql developer from windows 10?

1178