DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP BY eid);

write a query to delete similar records in particular
fields(columns) in different tables

Question Posted / rajesh

Answer Posted / rajesh

DELETE emp WHERE ROWID NOT IN(SELECT MIN(eid)FROM emp GROUP
BY eid);

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Is sql workbench free?

522

how would you get the current date in mysql? : Sql dba

531

How do I view a procedure in sql?

543

Is pl sql a scripting language?

578

What does count (*) mean?

517

What is a left inner join?

529

how to present a past time in hours, minutes and seconds? : Sql dba

550

What is case function?

590

what is an index? : Sql dba

515

Does google use sql?

504

what is 'mysqladmin' in mysql? : Sql dba

525

How many types of normalization are there?

485

What are the string functions in sql?

523

what is a foreign key ? : Sql dba

599

what are date and time functions in mysql? : Sql dba

528