Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 18851 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / raghavendraprasad
delete from table_name where rowid not in (select max
(rowid) from table group by duplicate_values_field_name);
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are sql objects?
How do I view output in sql developer?
What is a full join sql?
What is recursive stored procedure?
What are dml commands?
Is sqlite thread safe?
What is the difference between sql and mysql?
what is a composite key ? : Sql dba
what are sequences
what is a composite primary key ? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Why do we use joins?
What is a heap in sql?
Do prepared statements prevent sql injection?
What are functions in sql?
