update e2 set e2.name= e1.name from emp2 e2 join emp1 e1 on e1.id=e2.i

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 / pradip jain

8 Answers
12430 Views
I also Faced
E-Mail Answers

Answer Posted / pradip jain

update e2
set e2.name= e1.name
from emp2 e2
join emp1 e1 on e1.id=e2.id

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What information is maintained within the msdb database?

954

Do you know what are different types of replication in sql server?

1075

Explain in details security in SQL azure?

121

What is the index requirement in SQL Azure?

What is SQL Azure Firewall?

136

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

976

What are scalar functions?

981

Name few endpoints exposed by ssrs 2012?

355

Explain what are the basic functions for master, msdb, model, tempdb databases?

951

What is indexing a document?

1020

Tell me what do we need queues in sql service broker?

971

What are wait types?

1086

What are the differences between ms sql server & oracle?

1036

Write a SQL query in order to merge two different columns into single column?

1022

What is the difference between char and varchar2 datatype in sql?

1049