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

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

Question Posted / khandu shinde

Answer Posted / khandu shinde

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

Is This Answer Correct ?

7 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Is sql considered coding?

1050

What does rownum mean in sql?

1033

What are analytic functions in sql?

1033

What is null in pl/sql?

1077

Is sql database free?

984

What is indexes?

1063

How many primary keys can a table have?

1013

Define SQL and state the differences between SQL and other conventional programming Languages?

1224

Is ms sql traffic encrypted?

929

How do I run a program in pl sql?

1008

Can we alter stored procedure?

993

Can we use ddl statements in stored procedure?

1154

What is a sql profiler?

1032

How to avoid duplicate records in a query?

1012

How do sql databases work?

1004