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 localdb mssqllocaldb?

1064

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

954

What is sql integrity?

1142

What is the use of sqlerrd 3?

936

What is mdf ldf and ndf?

990

What is normalisation and its types?

995

What is the difference between database trigger and stored procedure?

1066

What are the types pl/sql code blocks?

1121

how to rename an existing table in mysql? : Sql dba

1055

Why we use pl sql?

955

How do sql triggers work?

1032

How do I enable sql encryption?

1018

How do I sort a table in sql?

1025

What is the difference between Union and Union all. Which is faster.

1398

What is an invalid partition table?

1022