mysql分组统计,按照时间排序

select  t.* from 
  (select * from 
  myt_market_class_draw_img where uid = #{uid} and clz_id = #{clzId} and clz_type = #{clzType}     and delete_flag = 1 order by insertTime desc
  ) t GROUP BY play_id ORDER BY insertTime DESC

 条件写在内部

原文地址:https://www.cnblogs.com/mfser/p/9720544.html