select distinct * from Mytable select distinct * into Newtable from Mytabl

1) how to delete duplicate records from table in sql server
2005

2) what is run time polymorphism

Question Posted / kishore

Answer Posted / kishore

select distinct * from Mytable
select distinct * into Newtable from Mytable
drop table Mytable
select * into Mytable from Newtable

Is This Answer Correct ?

12 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What are the 2 kinds of data type conversions in c#?

818

Should I use double or float?

849

Explain the difference between .net and c#?

878

What are the two kinds of properties in c#.

884

Is there a way of specifying which block or loop to break out of when working with nested loops?

942

What is toint32 c#?

995

When a Static Constructor is called in a Class?

984

How many types of inheritance are there in c#?

857

Why to use lock statement in c#?

870

What are methods c#?

834

Describe an abstract class?

929

What is a strong name in c#?

1308

Write a C# program to find the Factorial of n

923

What is yield c#?

810

What does break do in loop?

878