您可以通过以下语句实现上述查询功能：
tmp_t = select *,denseRank(qyt) as ranking from t context by area order by area ,ranking desc select id,area,qyt,rowNo(ranking)+1 as ranking from tmp_t context by area
如何实现MYSQL中的row_number()功能
2 个回答
1.30.21/2.00.9 及之后版本，rank 参数 tiesMethod 支持 ‘first‘ ，上述脚本可以写为：
select *, rank(qty, ascending=false, tiesMethod='first') + 1 as ranking from t context by area order by area, ranking