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?
Answers were Sorted based on User's Feedback
Answer / dhana
update e2 set e2.empname = e1.empname
from emp2 e2,emp1 e1
where e1.empid = e2.empid
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / vidya
update emp2 set empname =e.empname from emp1 e where
e.empid =emp2.empid
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / a
Update emp2 set empname = (Select empName from emp1 where
emp2.empid =emp1.empid)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / 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 |
Answer / 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 |
Answer / rajesh.a
Update e2
set e2.empname=e1.empname
from
emp2 e2 inner join emp1 e1 on e1.empid=e2.empid
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
what is the cursor life span?
Explain a differential backup?
How many types of TRIGGERS are there in MS SQL Server?
8 Answers CarrizalSoft Technologies, TCS, United Healthcare,
What does dml stand for?
How does stuff differ from the replace function?
What is exporting and importing utility?
Can you type more than one query in the query editor screen at the same time?
What is the significance of master, tempdb and model databases?
Can a table have 2 primary keys?
what is unique and xaml nonclustered index
What is the difference between a "where" clause and a "having" clause?