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
- 19267 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 is sql in mysql? : Sql dba
Explain what is an index?
What is the use of & in pl sql?
Can we delete column in sql?
how can we destroy the cookie? : Sql dba
How do you rank data in sql?
Explain the difference between 'between' & 'and' operators in sql
How long does it take to learn pl sql?
How delete all data from all tables in sql?
Can ddl statements be used in pl/sql?
What are the possible values for the boolean data field?
What are all the common sql functions?
What is a data definition language?
What is the syntax and use of the coalesce function?
What is query execution plan in sql?
