(select *
from (select row_number() over(partition by productid order by commentsequence) rn,
t.*
from tscm_productgeneral11 t
where t.generalinfocode = 1005)
where rn = 1) t2,
取某一列的最大值
最新推荐文章于 2021-09-06 21:07:35 发布