我有一张表格，其中包含根据期间的值
我只选择更改
例子：
表格栏：
Member
Status
Period
表格数据：
会员资格期限
----------------------
斧1
斧2
AY 3
AY 4
BX 1
BX 2
BX 3
BZ 4
我想查询返回这样的东西
Member A Status change X to Y Period 2 to 3
Member B Status change X to Z Period 3 to 4
我遇到了问题，因为Oracle不允许在子查询中进行排序
任何查询的想法？
您可以为此使用窗口函数：
select *
from (
select member,
status,
period,
lag(status) over (partition by member order by period) as prev_status,
lag(period) over (partition by member order by period) as prev_period
from the_table
)
where status <> prev_status
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句