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

What is a scalar value in sql?

1122

How to Declare Fixed Length String Value In PL SQL

1207

How do you use a while loop in pl sql?

1052

what is the difference between a local and a global temporary table? : Sql dba

1126

what is heap table? : Sql dba

1136

What view means?

1025

Name three sql operations that perform a sort.

1062

how to convert numeric values to character strings? : Sql dba

1156

Explain what is a view?

1115

What is cursor status?

1236

What is a nested table in word?

1009

Explain sql data types?

1143

explain advantages of innodb over myisam. : Sql dba

1175

how to use case expression? : Sql dba

1078

Which data dictionary views have the information on the triggers that are available in the database?

1297