Interested to Buy Any Domain ? << Click Here >> for more details...
In EMP table, for those emp whose Hiredate is same, update
their sal by "sal+500" or else for others keep the sal as it
is, how to do it by SQL query
- 8 Answers
- 14397 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sukanta
update emp a set a.sal=a.sal+500 where a.hiredate in(select
max(b.hiredate) from emp b group by b.hiredate having
count(b.hiredate)>1);
or
update emp a set a.sal=a.sal+500 where a.hiredate=(select
max(b.hiredate) from emp b where a.hiredate=b.hiredate group
by b.hiredate having count(b.hiredate)>1);
above is Posted By
Sukanta
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is joiner transformation?
What is informatica metadata and where is it stored?
What are the modules in Power Center
What is transformation?
What is informatica etl tool?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is joiner transformation in informatica?
where to store informatica rejected data?
What is a dimensional model?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Write the prerequisite tasks to achieve the session partition?
Differences between connected and unconnected lookup?
What is pmcmd command?
What are the conditions needed to improve the performance of informatica aggregator transformation?
