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

The select into statement is most often used to create backup copies of tables or for archiving records?

1073

Is sql sequential or random?

1042

What is sql engine in oracle?

998

Can we use joins in subquery?

1170

What is a join?

1076

What is memory optimized?

1093

What is difference between hql and sql?

1087

What is database sql?

1059

What is the most common sql injection tool?

1050

What is delete command in sql?

1125

how to check server status with 'mysqladmin'? : Sql dba

1086

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

1018

What are the types of operators available in sql?

1076

Why do we create views in sql?

1159

What is write ahead logging in sql server?

1059