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 is the use of dll file in c#?

643

what is the difference between .dll and .exe

720

Is c sharp open source?

645

What is eager and lazy loading in c#?

629

What is meant by generics in c#?

667

What are the methods in c#?

692

Can constructor be overloaded in c#?

642

Can a dictionary have duplicate keys c#?

665

What is an event in c#?

667

4. Describe the process when we send a request URL? And who is responsible for that?

1708

Is class reference type c#?

705

What is a lambda expression in c#?

929

What does static mean in c sharp?

786

What is the difference between C# 3.5 and C# 4.0?

718

What are the fundamental principles of oo programming?

781