delete from emp x where rowid>(select rowid from emp y where x.sal=y.sa

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

13 Answers
23667 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

Answer Posted / suneelkumar

delete from emp x where rowid>(select rowid from emp y where
x.sal=y.sal)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is subquery? : Sql dba

1132

Are views faster than queries?

987

how to create a table index in mysql? : Sql dba

1059

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1087

how can we destroy the cookie? : Sql dba

1010

Is sql a backend language?

1091

What is normalization? How many normalization forms are there?

1080

What operators deal with null?

1100

What are the features of pl sql?

1064

How many tables can a sql database have?

972

How many types of literals are available in pl sql?

1113

Is sql a programming?

970

Explain locks? : Transact sql

997

What is native sql query?

1015

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1223