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

How are sql commands classified?

1143

What is the use of triggers?

1084

What is an emotional trigger?

1058

what is the use of friend function? : Sql dba

1063

What is percent sign in sql?

1327

Explain character-manipulation functions?

1176

Explain the types of joins in sql?

1075

What are all the ddl commands?

1244

What is the use of sqlerrd 3?

994

how can we optimize or increase the speed of a mysql select query? : Sql dba

989

how to start mysql server? : Sql dba

1239

What is thread join () in threading?

1057

What is partition in sql query?

1047

What is the difference between syntax error and runtime error?

1185

Where is pl sql used?

1006