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

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

959


How to get a list all databases on the sql server?

1088


What is the difference between a primary key and a unique key? Are they the same?

1070


Can you always create a cache of a report?

172


Why do we use stored procedures in sql server?

930


What is the difference between for auto and for nested?

997


What is a unique index?

925


What is self contained multi valued query?

1006


What is the New in SQL server 2008?

962


How to count groups returned with the group by clause in ms sql server?

1055


What are the dis_advantages of stored procedures, triggers, indexes?

2213


What is the difference between ddl,dml and dcl commands?

1106


What is scrollable cursor?

1028


How to include date and time values in sql statements?

1078


What is clustered index

994