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
How can you fetch common records from two tables?
What is the purpose of a sql?
What is the clause we need to add in function body to return variable?
What is a heap in sql?
What is set serveroutput on in pl sql?
What is a clob in sql?
What version is sql?
what is an extent ? : Sql dba
What will you get by the cursor attribute sql%notfound?
Why do we create views in sql?
What is the difference between distinct and unique in sql?
What is the difference between left and left outer join?
How does cross join work?
Can we use ddl statements in stored procedure sql server?
What is trigger in pl sql with examples?