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
- 18940 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
Is truncate ddl or dml?
Which tcp/ip port does sql server run?
What are all the different normalization?
What is a composite primary key?
How to Declare Fixed Length String Value In PL SQL
How delete all records from table in sql?
What is trigger with example?
What is difference between group by and partition by?
How many types of relationship are there?
How do I order columns in sql?
What is scope of pl sql developer in future?
what is a field in a database ? : Sql dba
Is pl sql different from sql?
What is a native sql query?
Is there a 64 bit version of ssms?
