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 delete duplicate rows from table

Answer Posted / kumar.t

Navaneethakrishnan your query only delete id 1 but not
delete remaining records.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can multiple columns be used in sql group by clause in ms sql server?

1115


What are the different types of normalization?

1221


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1110


Where are sql server user names and passwords stored in sql server?

1154


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2822


What is provisioning, billing and metering, and connection routing concepts in the service layer?

115


Why is normalisation important?

989


Why we use the openxml clause?

1055


Why SQL Agent is used?

1204


Define primary key?

1198


What area unit the various kinds of info compression introduced in sql server 2008?

1139


How sql server enhances scalability of the database system?

1315


What are the restrictions while creating batches in sql server?

1113


What is the full form of dql?

1024


What is the difference between cartesian product and cross join?

904