17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM (
SELECT T.*, ROW_NUMBER() OVER(PARTITION BY ID,NODE ORDER BY CREATE_TIME DESC) RN FROM T_TABLE
)WHERE RN= 1
SELECT ID,NODE,SUBSTR(MAX(CREATE_TIME||USER),9,1)
FROM T
GROUP BY ID,NODE
SELECT * FROM (
SELECT T.*, MAX(CREATE_TIME) OVER(PARTITION BY ID,NODE) MAX_CREATE_TIME FROM T_TABLE
)WHERE CREATE_TIME = MAX_CREATE_TIME
select a.id,a.node,a.user from (select id,node,max(create_time),user from 表 group by id,node) a