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

Is db2 relational database?

1044


What is database reorganization?

1185


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1133


What is drop table?

1067


Which isolation level provides highest data integrity?

1186


Is db2 a mainframe database?

1048


What is null in db2?

1068


What is deadlock in db2?

1121


What is db2 bind?

1130


What is bind package and plan in db2?

1107


Is it possible using max on a char column?

1192


What is a bind in db2?

1105


What are concurrency issues?

1170


What is plan in cobol db2?

1203


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1289