Increment with 5% the salary of one of records
How can i solve this problem?
Collapse
X
-
Hi,Originally posted by parmissIncrement with 5% the salary of one of records
your question is not very clear to me. i have assumed the problem in a following way, and i hope it is correct. If not please get back with a correct problem statement.
if u have any other column in ur table like emp_ID, emp_name.. etc,,, with reference to tat column u can update the salary column of a particular record.
for example:
update tab_name set salary= salary+(0.05*sa lary) where emp_ID=123445
then try to display the record by "select * from tab_name" statemt.
Comment