--所有人的实发工资总数中
select
[100面值]=实发工资/100,
[50 面值]=实发工资%100/50,
[10 面值]=实发工资%100%50/10,
[5 面值]=实发工资%100%50%10/5,
[1 面值]=实发工资%100%50%10%5
from(select 实发工资=sum(实发工资) from 工资表)a
select
[100面值]=实发工资/100,
[50 面值]=实发工资%100/50,
[10 面值]=实发工资%100%50/10,
[5 面值]=实发工资%100%50%10/5,
[1 面值]=实发工资%100%50%10%5
from(select 实发工资=sum(实发工资) from 工资表)a
select 姓名,实发工资,
[100面值]=实发工资/100,
[50 面值]=实发工资%100/50,
[10 面值]=实发工资%100%50/10,
[5 面值]=实发工资%100%50%10/5,
[1 面值]=实发工资%100%50%10%5
from 工资表
set @a=2598select [100元]=@a/100
,[50元]=@a%100/50
,[20元]=@a%100%50/20
,[10元]=@a%100%50%20/10
,[5元]=@a%100%50%20%10/5
,[2元]=@a%100%50%20%10%5/2
,[1元]=@a%100%50%20%10%5%2/1--結果
100元 50元 20元 10元 5元 2元 1元
---------------------------------------------------------
25 1 2 0 1 1 1
[50面值] = Sum([实发工资]%100/50),
[20面值] = Sum([实发工资]%100%50/20),
[10面值] = Sum([实发工资]%100%50%20/10),
[5面值] = Sum([实发工资]%100%50%20%10/5),
[2面值] = Sum([实发工资]%100%50%20%10%5/2),
[1面值] = Sum([实发工资]%100%50%20%10%5%2)
from [工资表]