我使用以下查询: select country_name from (SELECT country_name, rank() OVER (ORDER BY TOTAL_pop desc)
as rkParseException line 1:197 cannot recognize input near ')' 'SUM_EMP' 'where' in subquery source 请帮我做同样的事
所以我有这个关系国家(名称,代码,首都,省,面积,人口)select name, population(select distinct name, population from country order by populationdesc limit 2) as A
order by population asc li