sql 语句在DB中可以查出几万条，但python调用此sql后去掉where只能查出几百条 ,加上where只能30条 不知哪里有问题

Question

select sh_code,cast(trx_date as date) opendate,cashi_no,trx_type, count(trx_no) cunt from trx_hdr group by cast(trx_date as date),sh_code,cashi_no,trx_type having cast (trx_date as date) >='2021-01-01' order by sh_code"

where substring(cashi_no,5,2) in ('21','22') and cashi_no like('____21%') or cashi_no like('____22%') group by cast(trx_date as date),sh_code,cashi_no,trx_type having cast (trx_date as date) >='2021-01-01' order by sh_code
我在sql server 执行有几万条记录，放到python 只有几百条 不知什么问题

Answer 1

确认是同一个数据库，其它条件一样吗。