Interested to Buy Any Domain ? << Click Here >> for more details...
I have a table emp , Fields with empname,dnname,dno,salary.
now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
- 2 Answers
- 3945 Views
- Techno Labs, I also Faced
- E-Mail Answers
Answer Posted / prashant
SELECT DISTINCT empname,dnname,dno,salary into New Table
from emp
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is format parameter in ssrs?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the differences between decimal and float in ms sql server?
What are different types of collation sensitivity?
What is the use of keyword with encryption.
What is the difference between functions and stored procedures?
Why do we use non clustered index?
How do you know if sql server is running on your local system?
What do you understand by coalesce in sql server?
Can you explain what is indexed view? How to create it?
What is data block and how to define data block size?
Explain SSRS Architecture?
Can we use trigger new in before insert?
Can you please explain the difference between function and stored procedure?
What is the difference between migration and upgradation in sql server?
