按列排序

SELECT a.bId, Sum(a.lngCost) AS lngCost之总计, round(lngCost之总计/sCost,2)
FROM tblTest a,(select sum(lngCost) as sCost from tblTest) b
GROUP BY a.bId,b.sCost
order by  lngCost之总计 desc;

 

在ACCESS中使用上述查询，排序字段lngCost之总计会被当做参数，执行该查询会弹出对话框，要求输入参数“lngCost之总计”的值，改成数字就可以了，像下面这样：

SELECT a.bId, Sum(a.lngCost) AS lngCost之总计, round(lngCost之总计/sCost,2)
FROM tblTest a,(select sum(lngCost) as sCost from tblTest) b
GROUP BY a.bId,b.sCost
order by 2 desc;