1. Select from <table name A> where rowid

How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?

Question Posted / anil kumar karasi

15 Answers
33021 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

Please Help Members By Posting Answers For Below Questions

What is self join in sql server joins?

1118

What are a scheduled jobs or what is a scheduled tasks?

945

What is schemabinding a view?

971

What do you know about system database? : SQL Server Architecture

1039

How to replace the Query Result 'Null Value' with a text ?

1095

What stored by the model?

1139

What is join query?

938

how many layers of tcp/ip protocol combined of? : Sql server database administration

1050

Which tcp/ip port does sql server run on? How can it be changed?

1083

Which Model uses the SET concept

1043

What does Master database contains?

1182

Why do we backup Active Directory ?

1099

How to list all objects in a given schema?

1107

Please explain what is “asynchronous” communication in sql server service broker?

982

What is a dataset and what are the different types of datasets?

141