我写了一个查询语句,用来统计平均工资,级最大,最小工资,用dbgrid显示,如下select department_name, avg(salary) as "avg_salary", max(salary)as "max_salary", min(salary) as "min_salary"
from employeeview
group by department_name
department_name avg_salary max_salary min_salary
----------------------------------
Accounting 5136.5 12000.0 123.0
Administration 293445.875 2341231.0 123.0
Benefits 137301952.44444445 1234567890.0 13.0
Construction 506.33333333333331 2423.0 123.0
Corporate Tax 17068.0 34123.0 13.0
Executive 19333.333333333332 24000.0 17000.0
Sales 8955.8823529411766 14000.0 6100.0
Shipping 3475.5555555555557 8200.0 2100.0平均工资一栏数字显示位数过多,请问怎样才能控制显示精度啊!
from employeeview
group by department_name
department_name avg_salary max_salary min_salary
----------------------------------
Accounting 5136.5 12000.0 123.0
Administration 293445.875 2341231.0 123.0
Benefits 137301952.44444445 1234567890.0 13.0
Construction 506.33333333333331 2423.0 123.0
Corporate Tax 17068.0 34123.0 13.0
Executive 19333.333333333332 24000.0 17000.0
Sales 8955.8823529411766 14000.0 6100.0
Shipping 3475.5555555555557 8200.0 2100.0平均工资一栏数字显示位数过多,请问怎样才能控制显示精度啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货