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 reorg and runstats in db2?

1211


What is the difference between db2 and oracle?

1115


When do you specify the isolation level?

1023


Define check constraint.

1066


Why do we need reorg in db2?

979


What is the maximum length of sqlca?

1512


What is meant by dclgen?

1097


What are concurrency issues?

1086


What is db2?

1165


Explain about dbrm.

1033


What is bind in db2?

1030


What is db2 bind?

1069


What is the purpose of using commit?

1086


What is meant by explain?

1120


What is the default page size of buffer pools?

1118