写出HQL
1)表ordertable,字段(购买用户:userid,金额:money,购买时间:paymenttime(格式:2017-10-01),订单id:orderid)
2)求所有用户中在今年10月份第一次购买商品的金额
千锋教育
select userid,
money,
paymenttime,
orderid
from (
select userid,
money,
paymenttime,
orderid,
row_number() over(partition by userid order by paymenttime desc) `rank`
from ordertable
where date_format('paymenttime','yyyy-MM') = '2017-10'
) t1
where t1.rank = 1