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

What is cold data?

897

What is index example?

951

What is Collation Sensitivity ? What are the various type ?

904

What are triggers in sql?

972

How many types of sql are there?

929

Can I create table without primary key?

938

how to see the create table statement of an existing table? : Sql dba

946

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

953

What are the parameter modes supported by pl/sql?

1019

What will you get by the cursor attribute sql%notfound?

1012

What is a file delimiter?

1013

What is a primary key? Explain

920

how would you enter characters as hex numbers? : Sql dba

936

Which are the different character-manipulation functions in sql?

987

Mention what plvcmt and plvrb does in pl/sql?

1061