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 will you delete duplicate records from a table?

Answer Posted / mehdee

Hi. This is a database design problem, because if you
alowe duplicate rows then you must have at least a column
being like squence number.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about cursor stability?

982


Name the various locking levels available?

1035


What is a system catalog table in db2?

1101


can all users have the privilage to use the sql statement select * (dml)?

1103


How to check last update on table in db2?

1001


What is the maximum size of varchar data type in db2?

1066


What is the reason behind not using select * in embedded sql programs?

1044


What is the maximum size of a char data type in db2?

964


What is the syntax for creating a table in the db2 database?

1058


What is declare cursor?

1043


How to run db2 command in windows?

1136


what is the role of the cursor in db2?

1000


How to test SQL -911 error while developing COB-DB2 program

7442


What is database reorganization?

1053


Define check constraint.

1026