Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 32614 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / anil kumar karasi
1.
Select from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);
2.
Delete from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);
| Is This Answer Correct ? | 12 Yes | 9 No |
Post New Answer View All Answers
What are the steps you can take to avoid “deadlocks”?
What is the parse query button used for?
What were the latest updates to SQL Azure service?
Do you think BCNF is better than 2NF & 3NF? Why?
What are the different types of subquery?
Tell me in brief how sql server enhances scalability of the database system?
Which language rdl files made of?
What are the new data types are introduced in sql 2000?
How do I find my localdb version?
List out the differences between global and local temp tables in sql server?
how many bits ip address consist of? : Sql server database administration
Give an example of SQL injection attack ?
What is 3nf normalization form?
How to convert character strings into numeric values?
Which tools are available to manage SQL Azure databases and servers?
