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

Is a primary key unique?

1035

What are information schema views?

1027

Explain primary key and foreign key constraints?

1089

Sql server reporting services vs. Crystal reports.

140

Explain about Joins?

1034

What are the benefits and tasks of object explorer? : sql server management studio

1250

How to use "begin ... End" statement structures in ms sql server?

1115

can a table be moved to different filegroup? : Sql server administration

1018

How do I edit a stored procedure in sql server?

970

Do you know the different ddl commands in sql?

1098

What is sql collation?

1266

What are truncate options available in sql server? : sql server database administration

1081

How retrieve field names from the table in SQL through JAVA code?

1954

What does top operator do?

1074

Where are SQL server users names and passwords are stored in sql server?

1324