delete from emp where rowid not in (select max(rowid)

write a query to delete similar records in same table

Question Posted / kirankumar.vangeti

Answer Posted / kirankumar.vangeti

delete from emp
where rowid not in (select max(rowid)
from emp
group by emp_number);

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between rollback and rollback to statements?

1046

What is dense_rank in sql?

954

Can function return multiple values in sql?

1028

How many tables can a sql database have?

958

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1022

What is an intersect?

1085

What is a schema sql?

1122

How do you change a value in sql?

997

Where is sql database stored?

959

What are triggers and its uses?

1032

Is left join inner or outer by default?

1005

How does postgresql compare to oracle/db2/ms sql server/informix?

1015

What is the most important ddl statements in sql are?

979

What is a primary key called that is made up of more than one field?

1330

What is ttitle and btitle?

1046