select sn, pname, srnum, rerepairtime, rn
from
(
select sn,pname, srnum, rerepairtime,row_number() over(partition by assetsid order by rerepairtime desc) rn
from atzserreportb
)
where rn = 1
转载于:https://www.cnblogs.com/xsmhero/p/3897450.html
select sn, pname, srnum, rerepairtime, rn
from
(
select sn,pname, srnum, rerepairtime,row_number() over(partition by assetsid order by rerepairtime desc) rn
from atzserreportb
)
where rn = 1
转载于:https://www.cnblogs.com/xsmhero/p/3897450.html