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
- 4084 Views
- Techno Labs, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prashant
SELECT DISTINCT empname,dnname,dno,salary into New Table
from emp
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / b.kumar
WITH CTE
AS
(
SELECT *, ROW_NUMBER() OVER (PARTITION BY SAL ORDER BY SAL) AS ROWID
FROM EMP7
) SELECT * INTO EMP10 FROM CTE WHERE ROWID=1
| Is This Answer Correct ? | 1 Yes | 0 No |
Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer
How do you read transaction logs
Can binary strings be converted into numeric or float data types?
How to execute a stored procedure in ms sql server?
Explain error handling in ssis?
What does man by sql wildcard characters in sql server?
tell me the disaster recovery plan
What are user-defined functions (udfs) in sql server?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
What are policy management terms?
What is the difference between primary key and unique constraints?
how can i store resumes in database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
