how to copy only distinct data into another table which is not already exist in database?
- 2 Answers
- 3636 Views
- Spectra, I also Faced
- E-Mail Answers
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 is the need for indexing?
What happens if null values are involved in bitwise operations?
What is the sql case statement used for?
Explain in details security in SQL azure?
What have included columns when we talk about sql server indexing?
How do I debug a stored procedure in sql server?
How would we use distinct statement? What is its use?
Can you explain various data region available in ssrs with their use?
Explain error and transaction handling in sql server?
What does the on delete cascade option do?
What is the security principal at the database level that represents your session?
How to write an inner join with the where clause in ms sql server?
What is named calculation? : sql server analysis services, ssas
What is the distinction amongst delete and truncate?
Explain trigger classes i.e. Instead of and after trigger?
