Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24535 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / nirmalendu
delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);
** column_name which having duplicate record
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the usage of distinct keyword?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How many types of keys are there in sql?
What is cartesian join in sql?
Can dml statements be used in pl/sql?
How many types of functions are there in sql?
What is sql procedures and functions?
Is sqlite good enough for production?
What are the topics in pl sql?
How to load data with sql*loader?
What are functions in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
How many sql statements are used?
Are pl sql variables case sensitive?
How do I delete a trigger?
