update emp2 e2 set e2.empname = (select e1.empname from emp1 e1 where e2

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 / vicky

8 Answers
12781 Views
I also Faced
E-Mail Answers

Answer Posted / vicky

update emp2 e2 set e2.empname = (select e1.empname from
emp1 e1 where e2.empid=e1.empid)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1038

List the various tools available for performance tuning?

924

What is open database communication (odbc)?

1116

What is normalization? Describe its different types.

1155

Does a server store data?

954

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1056

Where can you find the error log information? : sql server database administration

1072

Explain sql server service broker?

1026

What is repeatable read?

1093

What is the boxing and unboxing concept in .net?

977

What is the difference between dataadapter and datareader?

1058

Define right outer join?

1016

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

What are the components of sql server service broker?

1063

Explain about service Broker functions?

1089