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
- 11860 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / guest
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);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to join three sources using joiner?
What is informatica powercenter repository?
Describe the impact of several join conditions and join order in a joiner transformation?
What is workflow manager?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
what are the deliverables?in your project?
What is a mapplet/worklet in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Define the various join types of joiner transformation?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what are the Methods For Creating Reusable Transformations?
can anyone explain me about retail domain project in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the differences between oltp and olap?
