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

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

Question Posted / rakesh pattajoshi

Answer Posted / rakesh pattajoshi

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different pipelining hazards and how are they eliminated? : Dot net architecture

1034

What is gui programming? : .NET Architecture

933

What is the use of TPL DATAFLOW?

1053

where should I put this information then?

978

Use of Enable view state ? if turn off what happen ?

4486

I want to create a project like google maps how can we do that with atlas?

949

How can we integrate atlas with web services?

954

Why only boxed types can be unboxed?

1093

What happens to the winfx technologies?

1010

What other than biginteger has been introduced in system.numerics namespace?

959

What is IL code, CLR, CTS, GAC & GC?

1033

Can I customise the trace output?

1081

Explain the race around condition? : .NET Architecture How can it be overcome? : .NET Architecture

923

What is the difference between an application and a program?

936

What does the term "green architecture" mean? : .NET Architecture

969