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 schema in db2?

1015


What is the result of open cursor statement?

1073


What is query_cache_limit?

959


What is db2 connect?

1058


Is ibm db2 free?

998


How to check sequence on a table in db2?

1049


What are host variables in db2?

1043


What is the physical storage length of date data type?

1244


How will you return the number of records in table?

924


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2227


How many types of page locks can be held in db2?

1031


What is coalesce in db2?

1122


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11667


What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1178


What is iseries database?

1042