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

 条件写在内部

posted @ 2018-09-28 19:54  牧の风  阅读(2549)  评论(0编辑  收藏  举报