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
您可以通过以下语句实现上述查询功能:
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