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
- 18808 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
can a stored procedure call itself or recursive stored procedure? : Sql dba
what are the different tables present in mysql? : Sql dba
When can we use the where clause and the having clause?
Are subqueries better than joins?
Is subquery faster than join?
Explain mutating table error.
How do I quit sql?
What is a pl/sql block?
How do I start pl sql?
Why is nosql good?
how to rename an existing column in a table? : Sql dba
How to call a javascript function from pl sql?
What is a delimiter in sas?
Explain the order of sql statement execution?
what are numeric data types? : Sql dba
