写sql的时候,想要查找出同个确认单号的费用的汇率,有没有不同的情况:
本来是这么写的,但是发现完全不对
select confirm_no,tax_rate,count() as co from 费用表 group by confirm_no,tax_rate having co > 1
因为这样是统计,同个确认单号,同个汇率的数量。
正确结果是这样:
select confirm_no,count() as co from (select confirm_no,tax_rate from 费用表 where confirm_no = 'EKKORDC240800328' group by confirm_no,tax_rate)s group by confirm_no having co > 1
很简单的问题,居然顿了半天~