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 / channabasappa

select field name from tablename where group by field name
having count(field name)>1;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 schema?

1172


Explain what are the various isolation levels possible?

988


What is the meaning concurrency in the db2 database?

1055


How do you stop a db2 database in linux?

956


What is a page in db2?

980


What is the syntax for FETCH in DB2 ?

1136


What is db2 bind?

1015


What does a deadlock mean in DB2?

1094


What is reorg and runstats in db2?

1142


Is ibm db2 free?

952


What is db2 instance?

1015


What is the use of dclgen in db2?

1011


Which component is responsible for processing sql statements and selecting access paths?

1070


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1219


What is sqlca’s maximum length?

1101