select t.\* from (select \*,row_number() over (partition by product_type order by level desc) as order_num from short_forecast_product where base_time = '2023-09-19') t where order_num = 1; Loading... select t.\* from (select \*,row_number() over (partition by product_type order by level desc) as order_num from short_forecast_product where base_time = '2023-09-19') t where order_num = 1; 最后修改：2023 年 12 月 29 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 1 如果觉得我的文章对你有用，请随意赞赏
