数据查询出来的数据需要某个字段的值不能重复如bill_no
SELECT oy.id, oy.bill_no, oy.bill_status, oy.customer_id, oy.customer_name, oy.saler_id, oy.saler_name, oy.disabled_date, oy.`note`, oy.crt_time FROM oms_sale_inquiry oy SELECT MAX(oy.id), MAX(oy.bill_no), MAX(oy.bill_status), MAX(oy.customer_id), MAX(oy.customer_name), MAX(oy.saler_id), MAX(oy.saler_name), MAX(oy.disabled_date), MAX(oy.`note`), MAX(oy.crt_time) FROM oms_sale_inquiry oy GROUP BY oy.bill_no ORDER BY MAX(oy.crt_time) DESC去重完数据
