select * from(
SELECT ny,prod_id,SALED_CNT,
row_number()
OVER (PARTITION BY ny
ORDER BY SALED_CNT desc NULLS LAST) top_3
FROM table) b
where b.top_3<=3;
SELECT ny,prod_id,SALED_CNT,
row_number()
OVER (PARTITION BY ny
ORDER BY SALED_CNT desc NULLS LAST) top_3
FROM table) b
where b.top_3<=3;
FROM(SELECT prod_id FROM prod_saled Order by saled_cnt DESC)
WHERE ROWNUM <=3
我用了table