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
32527 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

How to select some specific rows from a table in ms sql server?

996

What is a unique index?

925

What are partitioned views?

979

What is RMS migrations?

2128

What is the data tier application?

169

what is blocking? : Sql server database administration

1025

Which sql server table is used to hold the stored procedure script?

940

Can a database be shrunk with users active?

1119

What is store procedure? How do they work?

1002

What is use of @@ spid in sql server?

1203

What is a transactions?

1033

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2033

Why truncate is ddl command?

1054

between cast and convert which function would you prefer and why?

949

How to provide values to user defined function parameters?

1001