mysql去除重复字段

数据查询出来的数据需要某个字段的值不能重复如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 

去重完数据