17,086
社区成员
发帖
与我相关
我的任务
分享
select 产品名, 总销量
from (select 产品名,
sum(销量) as 总销量,
row_number() over(order by sum(销量) desc) rn
from A
group by 产品名) T
where rn < 11
SELECT *
FROM (SELECT product_name, SUM(sale_num)
FROM sales
WHERE sale_date BETWEEN DATE'2014-08-04' AND DATE'2015-08-04'
GROUP BY product_name
ORDER BY 2 DESC)
WHERE ROWNUM <= 10;