一个用来进行子查询的例子,相当的经典。最开始想实现这个查询时,费了很大的力气,关键是还没弄好,最后师傅出马,搞出来这么一个查询,在此记录,以供以后查看
select userid, a from
(
SELECT userid ,count(userid) as a from return_cash_coupon WHERE create_time BETWEEN '2015-08-24 00:00:00' and '2015-08-25 23:59:59' GROUP BY userid ORDER BY count(userid)
) sub where sub.a>200