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 ?
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
Do you know what is blocking?
What is the synonym of join?
Disadvantages of the indexes?
Can we take the full database backup in log shipping?
What is sql injection and why is it a problem? : sql server security
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is public role in sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the correct order of the logical query processing phases?
What are the operating modes in which database mirroring runs?
What is attribute hierarchy? : sql server analysis services, ssas
If a table does not have a unique index, can a cursor be opened on it?
What are data resources?
Do you know how to implement service broker?
what is spatial nonclustered index