Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to select the duplicate rows from a table?

Answer Posted / mahesh vasudevan

Select <col-name> from table A1 and A2
where A1.Col = A2.Col.

This should be an inner join. Then you are finding the
intersection of the key values...if you want to find the
duplicates for all matching column of the rows code AND
condition for join with all those columns.....by the way
there are different easy ways to find it. but this is one of
the way.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ibm db2 client?

999


What are db2 tables?

1155


What is explain plan in db2?

1048


Why cursor is used in db2?

1083


Why db2 is called db2?

1103


What is bind plan?

1091


What does db2 blu stand for?

1212


What r the comman abends in db2, jcl and cobol???????

2307


What is dbrm library?

1112


Name the various locking levels available?

1129


What language is db2 written in?

1095


What is page size in db2?

1021


Is ibm db2 free?

1061


Explain in brief how does db2 determine what lock-size to use?

1083


How can we read records for specific member in CL? AND rpg?

755