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 #table in sql server?

994

explain how to create a new schema in a database? : Sql server database administration

1055

What is the default server name for sql server?

1087

What is nonclustered index on computed columns?

903

What is difference between cte and view?

854

What is change data capture (cdc) in sql server 2008?

976

How you trouble shoot when any job fails

1894

How to create an multi-statement table-valued function?

937

What is the difference between a "where" clause and a "having" clause?

1115

Explain four layers of abstraction microsoft architectured?

147

What is stretch database in sql server?

1025

Do you know what are the reporting services components?

916

What do you mean by an execution plan?

1050

When to use null data driven subscription?

196

Can you explain about buffer cash and log cache in sql server?

904