SELECT * FROM table_name WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM table

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / lakshya

Answer Posted / lakshya

SELECT * FROM table_name
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM table_name GROUP
BY table_columns);

Is This Answer Correct ?

9 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is procedure and function?

936

What is record variable?

934

How do you drop a trigger?

929

What is union and union all keyword in sql?

983

What is cursor in pl sql with examples?

964

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

923

Explain the difference between triggers and constraints?

931

What is primary key sql?

964

Mention what pl/sql package consists of?

945

Why query optimization is needed?

869

Is microsoft sql free?

1051

What is union?

1095

how to get a list of columns in an existing table? : Sql dba

922

What are the most important ddl statements in sql?

1037

What is clustered index in sql?

1010