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 explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is the name of reporting services config file and what’s it’s used for?
How do I setup a sql server database?
Explain what is the difference between union and union all?
Explain syntax for viewing trigger?
what stored procedure would you use to view lock information? : Sql server administration
what is a sub-report?
What is the most common trace flags used with sql server?
How to enable/disable indexes?
What is the purpose of the master database?
what's the difference between delete table and truncate table commands? : Sql server database administration
Which command is used for user defined error messages?
Explain what is log shipping?
What is the most common type of join?
What is the purpose of a table?