SQL:每天销售额前三的产品及销售额
2019-04-28 本文已影响2人
XIN71
SELECT
*
FROM
(
SELECT
shipping_date,
product_name,
sum( sales_amout ) amount,
ROW_NUMBER ( ) OVER ( PARTITION BY shipping_date ORDER BY sum( sales_amout ) ) b
FROM
sales.shipping_form
GROUP BY
shipping_date,
product_name
) lis
WHERE
b <=3
