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

Can we use views in stored procedure?

1037

Explain correlated query work?

1059

Is drop table faster than truncate?

997

how can we find the number of rows in a table using mysql? : Sql dba

1090

What is error ora-01000: maximum open cursors exceeded

1151

Is mariadb nosql?

1045

What is the usage of sql functions?

1150

Define select, insert, create, delete, update, drop keywords

1053

What does sql stand for?

1001

Can pl sql procedure have a return statement?

1033

What is group function in sql?

1027

What are inbuilt functions in sql?

1070

How do I find duplicates in sql?

938

What are the disadvantages of not performing database normalization?

1170

How do you run a query?

995