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
- 14307 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / sbvp
update emp set sal=sal+500
or
alter table emp modify sal=sal+500
| Is This Answer Correct ? | 1 Yes | 28 No |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain lookup transformation in informatica
In informatica workflow manager, how many repositories can be created?
What is joiner transformation in informatica?
What is the use of an aggregator cache file?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is transformation?
What is a snowflake schema?
what is $$$$?
What are mapplets?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the advantage of informatica?
What is parallel processing in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Enlist the advantages of informatica.
