尝试使用解析函数和子查询
select movie_id, movie_title, category, sales_amt from ( select movie_id, movie_title, category, sales_amt, row_number() over (partition by category order by sales_amt desc) r from movie) where r = 1
尝试使用解析函数和子查询
select movie_id, movie_title, category, sales_amt from ( select movie_id, movie_title, category, sales_amt, row_number() over (partition by category order by sales_amt desc) r from movie) where r = 1
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
