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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert data into view?

700


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

769


What is primary key and unique key?

799


What is cte sql?

746


How do you update sql?

737


What are the different types of joins in sql?

1204


Explain aggregate functions are available there in sql?

772


Is a view faster than a stored procedure?

737


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

791


How do I quit sql?

703


What is data type in sql?

753


What is the difference between inner join and natural join?

751


What is the use of sqlerrd 3?

707


What is the usage of when clause in trigger?

785


What is embedded sql in db2?

734