解决MySQL中varchar字段排序,多条数据相同字段提取
解决:select distinct(bill_id),bill_date,cust_name,payee,supplier from Billinfo order by CONVERT(bill_id,SIGNED) desc limit 100000000
解决MySQL中varchar字段排序,多条数据相同字段提取
解决:select distinct(bill_id),bill_date,cust_name,payee,supplier from Billinfo order by CONVERT(bill_id,SIGNED) desc limit 100000000