Excel Rank与SQL Rank
Excel Rank与SQL Rank
提问于 2018-12-07 10:06:21
我有以下困境。
我需要在rank中对数据进行排序，就像我在SQL中对数据进行排序一样，如下所示：
declare @table table
(id int identity primary key , batchid int)
insert into @table (batchid) select 10
insert into @table (batchid) select 35
insert into @table (batchid) select 35
insert into @table (batchid) select 35
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 11
insert into @table (batchid) select 4
insert into @table (batchid) select 10
insert into @table (batchid) select 11
insert into @table (batchid) select 4
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 4
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21
insert into @table (batchid) select 11
insert into @table (batchid) select 21
insert into @table (batchid) select 8
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21
insert into @table (batchid) select 10
insert into @table (batchid) select 21
select
batchid
, rank() over (partition by batchid order by id) [RANK]
from @table我看了很多YouTube视频和关于如何在Excel中使用rank的教程，但是我没有看到在上面的代码中可以看到rank的partition by选项。
参见下面的上述脚本的结果：
在Excel中可以使用什么公式来实现相同的结果？
回答 2
Stack Overflow用户
回答已采纳
发布于 2018-12-07 10:11:44
简单的公式很容易实现：
在单元格B1中，输入初始值1。然后，在B2中输入一个公式：
=IF(A1=A2,B1+1,1)那就一直拖下去。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/53667289
复制相关文章
相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号