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
- 14421 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
Describe data concatenation?
Where do we use mapping variables in informatica?
What are mapplets? How is it different from a Reusable Transformation?
What do mean by local and global repository?
What is the benefit of partitioning a session?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is difference between a gateway node and worker node?
How to go to the older version for a mapping?
What is joiner transformation?
What are the types of schemas we have in data warehouse and what are the difference between them?
What is the difference between informatics 7x and 8x and what is latest version?
What is the difference between a repository server and a powerhouse?
How many input parameters can exist in an unconnected lookup?
How do you take back up of repository?
