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
- 14606 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
waht type of interface is used for testing the data in informatica
How to update or delete the rows in a target, which do not have key fields?
What is a filter transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what is the complex transformation you used in informatica
COM components can be used in Informatica
What is standalone command task?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
what are the Methods For Creating Reusable Transformations?
What is decode in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Describe the impact of several join conditions and join order in a joiner transformation?
Define the various join types of joiner transformation?
What is DR strategy for Informatica project?
Explain about Informatica server process that how it works relates to mapping variables?
