5个回答
-
17600087735 初学数据Lv2
5#
缱绻 发表于 2020-4-18 11:44
参考这个哈 http://bbs.esensoft.com/thread-127827-1-1.html
还是不行，您看我得写法没问题吧？ 文件命名是：totalcount
select count(* ) from (
select
DISTINCT
cbd.settlement_serial,
cbd.container_number,
cbd.inspection_type,
cbd.tax_price,
cbd.created_at
from
cost_fee_detail cbd
left join cost_bill cb on cb.settlement_serial = cbd.settlement_serial
where cb.id = <#=@costid#>
order by cbd.created_at) as cost
