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
12184 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

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1019

How does index makes search faster?

922

Explain user defined functions?

948

Why do we partition data?

979

Explain important index characteristics?

985

Differentiate between sql temp table vs table variable?

834

What is the report builder?

131

What is merge statement?

1021

How many ways to create table-valued functions?

935

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1034

Explain a differential backup?

949

What is the default schema of your login session in ms sql server?

996

How to use group functions in the select clause in ms sql server?

996

When would you use the stored procedures or functions?

950

What is the use of @@spid?

958