SELECT 省, 市, GDP FROM ( SELECT 省, 市, GDP, ROW_NUMBER() OVER (PARTITION BY 省 ORDER BY GDP DESC) AS rank FROM Table ) AS ranked WHERE rank <= 3;
3 1

相关推荐

点赞 评论 收藏
分享

牛客热帖

更多
牛客网
牛客企业服务