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
What are the types of resultset?
How to see the event list of an existing trigger using sys.trigger_events?
How to select true false based on column value in sql server?
What are the grouping functions?
Explain how you can configure a running aggregate in SSRS?
What are the methods used to protect against sql injection attack?
What is a recursive stored procedure in sql server?
What do you mean by cardinality?
How to get a list of columns using the "sys.columns" view in ms sql server?
Explain isolation levels that sql server supports?
Explain what are the database objects? : SQL Server Architecture
How to drop an existing stored procedure in ms sql server?
Define a cross join?
how to take backup bcp out for a column in table in sql server?
How to copy the tables, schema and views from one sql server to another?