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 the use of sqlerrd 3?

993

What is sql keyword?

1043

Is primary key an index?

1032

what is collation? : Sql dba

1198

What is a sql profiler?

1063

Does sql require a server?

1055

Define a temp table?

1075

What is your daily office routine?

2315

How do you explain an index?

1327

How do I quit sql?

1003

Mention what are the benefits of pl/sql packages?

1151

What is the difference between delete and truncate statement in sql?

1122

What is trigger in flip flop?

1060

Is and as keyword in pl sql?

1010

What are packages in pl sql and also explain its advantages?

1118