update w set w.ename=q.ename from empn1 w, (select e.ename,e.empid from em

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?

Question Posted / saravanan

8 Answers
12786 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How to create a simple stored procedure in ms sql server?

1089

What is database replication? What are the different types of replication you can set up in sql server?

1017

What are the triggers in sql?

1168

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

995

How can we check the sql server version?

1128

Explain what is row_number function?

1083

Explain the creation and execution of a user-defined function in the sql server?

1113

Can you insert NULL in unique column?

1210

How to convert a table data in XML format in sql server?

2596

What is the rdl file?

141

Does partitioning improve performance sql server?

1030

What is the difference between a clustered index and a non-clustered index?

1057

How we can compare two database data?

998

What is in place upgrade in sql server?

1094

What is the use of keyword with encryption. Create a store procedure with encryption?

999