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 max nvarchar size?

522

Is a foreign key always unique?

535

How to Declare Fixed Length String Value In PL SQL

668

Is postgresql a nosql database?

537

Explain alias in sql?

585

What are the types of join and explain each?

582

How do I quit sql?

502

how to run 'mysql' commands from a batch file? : Sql dba

611

what is row? : Sql dba

714

How do I restart sql?

527

How to add new employee details in an employee_details table with the following details

652

can sql servers linked to other servers like oracle? : Sql dba

555

Can we edit a view in sql?

553

What are the query optimization techniques?

535

What is difference between rank () row_number () and dense_rank () in sql?

582