select *
from (select a.*,
row_number() over(partition by a.USER_ID order by a.CREATED_DT desc) rid
from LCMS_USER_ACTION a) t
where t.rid <= 3;
说明:partition 是Oracle中的按什么分组。
row_number()是Oracle中的函数。
select *
from (select a.*,
row_number() over(partition by a.USER_ID order by a.CREATED_DT desc) rid
from LCMS_USER_ACTION a) t
where t.rid <= 3;
说明:partition 是Oracle中的按什么分组。
row_number()是Oracle中的函数。