delete from employees where rowid NOT IN(select max(rowid) from employees G

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

9 Answers
11332 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / yaswanth

delete from employees where rowid NOT IN(select max(rowid) from employees GROUP BY salary)

Is This Answer Correct ?

7 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the difference between rename and alias?

1064

What is normalisation in sql?

1098

How can you load multi line records? : aql loader

1125

What is compute?

1149

What is difference between db2 and sql?

1046

What is offset and limit in sql?

1103

Why is a primary key important?

1104

Does truncate free space?

1064

Why select is used in sql?

1068

How do temporal tables work?

1018

Can procedure in package be overloaded?

1140

Why do we use set serveroutput on?

1011

What is the trigger in sql?

1001

What is snowflake sql?

1127

Why partition by is used in sql?

1083