update emp set sal=sal+500 or alter table emp modify sal=sal+500

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

Question Posted / sbvp

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

Please Help Members By Posting Answers For Below Questions

What is difference between a gateway node and worker node?

1145

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1957

What is joiner change?

1151

How to load last n records of file into target table - informatica

1083

How is union transformation utilized?

1016

What are data-driven sessions?

1218

What are the components of Informatica? And what is the purpose of each?

1058

What is decode in static cache?

1187

design of staging area?

2030

What are active transformations.

1659

Write the different tools in the workflow manager?

1071

What is meant by pre and post session shell command?

1165

What are the designer tools for creating transformations?

1120

Explain sql transformation in script mode examples in informatica

1141

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1093