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...

  1. Categories >> Software >> Microsoft Related >> Dot Net >> Dot Net AllOther
  2. Suggest New Category

How to delete the duplicate records in a table using sql
server

Question Posted / rakesh pattajoshi

Answer Posted / rakesh pattajoshi

delete from tbl where id not in(select max(id) from tbl group by name)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are end points, contract, address and bindings?

878

Explain about continuable exceptions?

914

What is Opf3

956

How to implement the display in the class printdoc (how to resolve the naming conflict) a: no naming conflicts

1011

What is an interrupt? : .NET Architecture

836

What is .net mobile forms? : Microsoft dot net mobile

869

Can I create my own permission set?

972

Explain difference between state server and sqlserver? : .NET Architecture

894

Explain the Lapsed Listener problem in .net

1103

What are bindings?

927

What is code access security (cas)?

958

What is difference between .net and visual studio?

922

What is .net mobile lists. Explain with an example? : Microsoft dot net mobile

842

What is private constructor? And it's use?

1031

What is a virtual memory? : Dot net architecture

903