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
Can we insert data into view?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is primary key and unique key?
What is cte sql?
How do you update sql?
What are the different types of joins in sql?
Explain aggregate functions are available there in sql?
Is a view faster than a stored procedure?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How do I quit sql?
What is data type in sql?
What is the difference between inner join and natural join?
What is the use of sqlerrd 3?
What is the usage of when clause in trigger?
What is embedded sql in db2?