select *
from (select row_number() over(partition by resourceid order by updatetime desc) rank,
*
from browser.st_resource_info_h ) rn1
where rank=1
select *
from (select row_number() over(partition by resourceid order by updatetime desc) rank,
*
from browser.st_resource_info_h ) rn1
where rank=1