使用分析函数row_number() over (partiion by … order by …)来进行分组编号,然后取分组标号值为1的记录
select s.*
from (
select *, row_number() over (partition by TableID order by id ) as group_idx
from VL_OA_Message
) s
where s.group_idx = 1
在这里插入图片描述
使用分析函数row_number() over (partiion by … order by …)来进行分组编号,然后取分组标号值为1的记录
select s.*
from (
select *, row_number() over (partition by TableID order by id ) as group_idx
from VL_OA_Message
) s
where s.group_idx = 1
在这里插入图片描述