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
- 11863 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
What are the features of complex mapping?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is enterprise data warehousing?
What is Index Caches size?
server hot-ws270 is connect to Repository B. What does it mean?
How can we delete duplicate rows from flat files?
How can you increase the performance in joiner transformation?
What are the static cache and dynamic cache in informatica?
How many input parameters can exist in an unconnected lookup?
Write the advantages of partitioning a session?
What you know about transaction control transformation?
What is DR strategy for Informatica project?
where to store informatica rejected data?
What are batches?
