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
- 14593 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 would you join a node to the already existing domain?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Have you worked with/created Parameter file
How we can create indexes after completing the load process?
What are the issues you have faced in your project? How did you overcome those issues?
What are the popular informatica products?
How you prepared reports for OLAP?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is an expression transformation?
How do you load only null records into target?
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?
Is there any way to read the ms excel datas directly into informatica?
What do you understand by a term domain?
Differentiate between reusable transformation and mapplet.
Write the unconnected lookup syntax?
