select
*
from
(
select
row_number() over(partition
by
id
order
by
time
desc
) rn, 表.*
from
表)
where
rn = 1
select
*
from
(
select
row_number() over(partition
by
id
order
by
time
desc
) rn, 表.*
from
表)
where
rn = 1