复制代码 代码如下:
select
*
from
(
select
userid,
classid,
remark,
row_number () over (
partition by userid,
classid
order by
addtime desc
) as row_bank
from
eng24vipcourseintention
) as ta
where
row_bank = 1
*
from
(
select
userid,
classid,
remark,
row_number () over (
partition by userid,
classid
order by
addtime desc
) as row_bank
from
eng24vipcourseintention
) as ta
where
row_bank = 1
==========================
partitionbyuserid,classid 这里是按什么分组, 注意一下。
本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址:https://www.ctvol.com/dtteaching/616532.html