我有这张桌子
我试过这个：
SELECT
PRODUCT,
PROVINCE,
MAX(TOTAL)
FROM
(
SELECT
PRODUCT,
PROVINCE,
SUM(INCOME) TOTAL
FROM SALES
GROUP BY PRODUCT,PROVINCE
)
GROUP BY PRODUCT,PROVINCE;
Yo me llamo Ralf-Yo me llamo Ralf-Yo me llamo Ralf
