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

Answer Posted / sheshu4040

SELECT DISTINCT * INTO TABLE_NEW FROM TABLE_EXISTING

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the function of sql server agent windows service?

542


State the difference between union and union all?

517


plss anybody specify tha constrian management system in dbms

1571


how you can move data or databases between servers and databases in sql server? : Sql server administration

481


What is nonclustered index with included columns ?

545






What are the requirements for sql server 2016?

535


Explain the concepts and capabilities of sql server?

541


What is difference between rollback immediate and with no_wait during alter database?

576


What are sql azure firewall rules?

85


Explain Capacity planning to create a database? and how to monitor it?

3746


How to list all triggers in the database with sys.triggers in ms sql server?

534


What is raid? : SQL Server Architecture

589


How many columns can exist together per table?

701


What are the types of joins in sql?

558


Why are sql functions used?

616