471,607 Members | 1,805 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,607 software developers and data experts.

How can i solve this problem?

Increment with 5% the salary of one of records
Nov 6 '06 #1
1 1068
Increment 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*salary) where emp_ID=123445

then try to display the record by "select * from tab_name" statemt.
Nov 7 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by BVM | last post: by
3 posts views Thread by Alex | last post: by
7 posts views Thread by Shapper | last post: by
reply views Thread by Jitesh | last post: by
27 posts views Thread by John Salerno | last post: by
8 posts views Thread by vj | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.