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 are the types of resultset?

952

How to see the event list of an existing trigger using sys.trigger_events?

1057

How to select true false based on column value in sql server?

996

What are the grouping functions?

920

Explain how you can configure a running aggregate in SSRS?

163

What are the methods used to protect against sql injection attack?

1046

What is a recursive stored procedure in sql server?

1147

What do you mean by cardinality?

888

How to get a list of columns using the "sys.columns" view in ms sql server?

945

Explain isolation levels that sql server supports?

1023

Explain what are the database objects? : SQL Server Architecture

1059

How to drop an existing stored procedure in ms sql server?

1015

Define a cross join?

988

how to take backup bcp out for a column in table in sql server?

2081

How to copy the tables, schema and views from one sql server to another?

1028