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
what types of replication are supported in sql server? : Sql server database administration
What is a join in sql? What are the types of joins?
Is mysql the same as sql server?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How to list all columns in a table using odbc_columns()?
Explain in brief about Microsoft SQL server?
How to rebuild all indexes on a single table?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is the difference between local and global temporary tables?
How real and float literal values are rounded?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Differentiate between mongodb vs. Sql server?
What is difference between join and natural join?
what is database replicaion? : Sql server database administration
Is the order of columns in the set clause important in ms sql server?