write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
Answer Posted / saravanan
update w set w.ename=q.ename from empn1 w,
(select e.ename,e.empid from empn e,empn1 a where
a.empid=e.empid) q where w.empid=q.empid
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are transactions in sql?
Which tcl commands are available on the sql server?
List out the difference between union and union all in sql server?
What types of replication are supported in sql server?
How to loop through result set objects using odbc_fetch_row()?
Explain insert into select statement?
What is temporal table?
Define Business Edition in SQL Azure?
How can delete duplicate records in cte in sql server?
What functions can a view be used to performed?
What is the downside of using udf?
What is autocommit mode in sql server?
How to create new table with "create table" statements?
What is stored procedures?
How can you insert values in multiple rows using one Insert statement?