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
- 14096 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sanjaygupta1981
UPDATE emp
SET sal=sal+500
WHERE hiredate IN (SELECT hiredate
FROM employees
HAVING COUNT(*)>1
GROUP BY hiredate)
The above query will update the records of all those employees
whose hiredate is same.
| Is This Answer Correct ? | 17 Yes | 5 No |
Post New Answer View All Answers
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is a grid in Informatica?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How do you load alternate records into different tables through mapping flow?
What is a standalone command task?
Explain the mapping variable usage example in informatica
Which means the first record should come as last record and last record should come as first record and load into the target file?
What happens when a session fails and you click on recover?
Explain in detail scd type 2 through mapping.
Write the prerequisite tasks to achieve the session partition?
Explain about cumulative Sum or moving sum?
Explain your project of banking domian.
Explain lookup transformation is active in informatica
Explain how many types of dimensions are available in informatica?
Sequence generator, when you move from develoment to production how will you reset
