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
- 18764 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / mkumar.it
delete <table_name> where rowid not in (select min(rowid)
from <table_name> group by <dup_rec_col>)
max(rowid) can also be used provided you have to retain the
latest value other wise min(rowid) is fine.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are synonyms in sql?
Is clustered index a primary key?
How to look at the current sql*plus system settings?
What is sap sql anywhere?
What is a sql profiler?
how many tables will create when we create table, what are they? : Sql dba
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 ?
Can I create table without primary key?
What does bitemporal mean?
what are the differences between require and include, include_once and require_once? : Sql dba
Is foreign key mandatory?
Explain clause in sql?
Explain what is a field in a database and record in a database?
What problem one might face while writing log information to a data-base table in pl/sql?
What are inbuilt functions in sql?
