Hi, I have manipulated Khandu Shinde answer because it will delete comp

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

Question Posted / satyam kumar

6 Answers
13885 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / satyam kumar

Hi,

I have manipulated Khandu Shinde answer because it will
delete complete row.

delete from emp where rowid not in ( select max(rowid) from
emp group by empno having count(redundantcolumnName) > 1)

Note: work only with Oracle.

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many sql databases can you have on one server?

1071

What is materialized view in sql?

914

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

943

What are the different types of constraints?

1166

explain advantages of myisam over innodb? : Sql dba

1060

Why we use sql profiler?

946

What are the different tcl commands in sql?

1162

What are the benefits of pl/sql packages?

1101

Explain correlated query work?

1044

Is it possible to pass parameters to triggers?

1095

What is difference between mysql and postgresql?

1133

Difference between global and parameter variables?

1959

How do I view a sql trace file?

1015

Explain constraints in sql?

1036

How do I view a table in sql?

998