help

simple　发表于：2009-09-23 10:08:26 　

复制

在如何让联合查询得出的数据精确到没小数，SQL内如何写

谢谢！

Top

蒋海兵发表于：2009-09-23 10:13:36

可以使用round函数，如rount(表达式或者数字，0)

Top

simple 发表于：2009-09-23 10:46:25

我的联合查询是这样的，请问用round函数如何写入，我不会，谢谢！

SELECT OpName,Bonus From 1LA
UNION ALL select OpName,Bonus From 1LB
UNION ALL select OpName,Bonus From 1LC
UNION ALL select OpName,Bonus From 1LD
UNION ALL select OpName,Bonus From 1BDA
UNION ALL select OpName,Bonus From 1BDB
UNION ALL select OpName,Bonus From 1BDC
UNION ALL select OpName,Bonus From 1BDD
ORDER BY Bonus;

Top

点燃一支烟发表于：2009-09-23 11:15:12

SELECT OpName,round([Bonus],0) as Bonus1 From 1LA
UNION ALL select OpName,round([Bonus],0) From 1LB
UNION ALL select OpName,round([Bonus],0) From 1LC
UNION ALL select OpName,round([Bonus],0) From 1LD
UNION ALL select OpName,round([Bonus],0) From 1BDA
UNION ALL select OpName,round([Bonus],0) From 1BDB
UNION ALL select OpName,round([Bonus],0) From 1BDC
UNION ALL select OpName,round([Bonus],0) From 1BDD
ORDER BY Bonus1;

试试

Top

总记录：3篇页次：1/1 9 1 :

Access交流中心

help