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
- 19180 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
The select into statement is most often used to create backup copies of tables or for archiving records?
What are the dml statements?
What is sql deadlock?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Which software is used for pl sql programming?
Is subquery faster than join?
What is the difference between null value, zero, and blank space?
What is difference between hql and native sql?
Why is normalization important?
What is a record in a database?
how many columns can be used for creating index? : Sql dba
What is the usage of nvl function?
What is an implicit commit?
Does varchar need length?
Is pl sql and postgresql same?
