SELECT DISTINCT * INTO TABLE_NEW FROM TABLE

how to copy only distinct data into another table which is not already exist in database?

Question Posted / sheshu4040

Answer Posted / sheshu4040

SELECT DISTINCT * INTO TABLE_NEW FROM TABLE_EXISTING

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is a join? : Sql server database administration

1251

How do you make a trace?

1025

What do you understand by recursive stored procedure?

930

What is default constraint in ms sql server?

1037

What is the ‘fillfactor’?

968

Tell me what is normalization? Explain different forms of normalization?

1030

How to create nested stored procedure?

1020

What do you understand by recursive stored procedures?

989

How to override dml statements with triggers?

1189

What are different types of roles provided by ssrs?

150

How do you rebuild an identity column?

949

What is a DBMS, query, SQL?

1047

How and why use sql server?

1009

How do I view a script in sql server?

1045

Explain something about security and SQL Azure?

134