update employee set DA = salary / 10;
update employee set TRA = salary / 20;
update employee set PF = salary / 10;
5 rows updated.
E_NO
|
E_NAME
|
DA
|
TRA
|
PF
|
SALARY
|
45
|
Ajay
|
2200
|
1100
|
2200
|
22000
|
46
|
Kumar
|
1000
|
500
|
1000
|
10000
|
47
|
Babu
|
500
|
250
|
500
|
5000
|
48
|
Ram
|
2500
|
1250
|
2500
|
25000
|
49
|
Vignesh
|
200
|
100
|
200
|
2000
|
No comments:
Post a Comment