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
- 14605 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
What is DR strategy for Informatica project?
Is stop and abort are same in informatica?
What are the designer tools for creating transformations?
Why filter transformation is an active one?
State the differences between sql override and lookup override?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain the types of transformations?
How to use procedural logic inside infromatica?
What all join we can perform in LOOKUP transformation?
How do you use reject loader.
expain about the tune parameters?
How to partition the Session?
How to join three sources using joiner? Explain though mapping flow.
How to create a non-reusable instance of reusable transformations?
