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
- 4175 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 do you understand by check constraint in sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
What is the current pricing model of SQL Azure?
Explain foreign key in sql server?
How do you delete duplicate records in sql server?
Does the unique constraint create an index?
Explain table valued parameters in sql server? Why tvp used?
Explain the truncate command?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
How to use old values to define new values in update statements in ms sql server?
In how many ways you can invoke ssrs reports?
How do clustered indexes store data?
How to transfer an existing table from one schema to another schema in ms sql server?
What are distributed partitioned views?
