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
- 3539 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
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Write the SQL query to drop, truncate and delete table.
Can you edit the .rdl code associated with a linked report?
Can sql servers linked to other servers like oracle?
Difference between connected and disconnected database in .net with sql server?
What is the distinction amongst delete and truncate?
Why do we use non clustered index?
what is a self join? : Sql server database administration
Define constraints and give an example of their use?
How can i Relate Tables in SSIS
What are different types of roles provided by ssrs?
Does windows server 2016 come with sql server?
What is an inner join?
What do mean by xml datatype?
What is surrogate key? : sql server analysis services, ssas
