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

select distinct from <field name> from <table name>

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2?

1226


How to run db2 command in windows?

1236


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

1285


What is difference between isnull and coalesce?

1100


What is the purpose of using commit?

1145


How can deadlocks be resolved?

984


What is package in cobol db2?

1158


How does db2 sample database connect?

1077


What is the difference between using bind () and rebind () methods of naming class?

1448


Mention some fields that are a part of sqlca.

1087


How can you classify the locks in db2?

1130


What is bind and rebind in db2?

1184


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

1172


What does db2 stand for?

1084


What is concurrency?

1295