如何根据值分组生成Sl.No [英] How to generate Sl.No based on the group by values

问题描述

我想生成一列作为Sl.No. (以下数据中的问题"列)该列必须基于行分组生成.

例如，

在"A"组中，我有4行.所以想生成1,2,3,4.
在"B"组中，我有7行.所以我想生成1,2,3,4,5,6,7.

我想动态生成组的"n"个数字.

如何在SQL查询中执行此操作?.

数据示例:
-------------
身份证号码Sl.No?角色EmpNo
1000 A 1经理9001
1002 A 2 Manager 9002
1003 A 3 Manager 9003
1004 B 1助理经理9004
1005 B 2助理经理9005
1006 B 3助理经理9006
1007 B 4助理经理9007
1008 B 5助理经理9008
1009 B 6助理经理9009
1010 B 7助理经理9010
1011 B 8助理经理9011
1012 C 1顾问9012
1013 C 2顾问9013
1014 C 3顾问9014
1015 C 4顾问9015
1016 C 5顾问9016
1017 C 6顾问9017

Hi,

I want to generate one column as Sl.No. (Question column in below data) This column has to generate based on the group by rows.

For Example,

In "A" group, i have 4 Rows. So want to generate 1,2,3,4.
In "B" group, i have 7 Rows. So i want to generate 1,2,3,4,5,6,7.

I want to generate "n" number of group dynamically.

How to do this in SQL Query..?

Example data:
-------------
ID Code Sl.No ? Role EmpNo
1000 A 1 Manager 9001
1002 A 2 Manager 9002
1003 A 3 Manager 9003
1004 B 1 Asst.Mgr 9004
1005 B 2 Asst.Mgr 9005
1006 B 3 Asst.Mgr 9006
1007 B 4 Asst.Mgr 9007
1008 B 5 Asst.Mgr 9008
1009 B 6 Asst.Mgr 9009
1010 B 7 Asst.Mgr 9010
1011 B 8 Asst.Mgr 9011
1012 C 1 Consultant 9012
1013 C 2 Consultant 9013
1014 C 3 Consultant 9014
1015 C 4 Consultant 9015
1016 C 5 Consultant 9016
1017 C 6 Consultant 9017

推荐答案

检查此 [ ^ ]帖子.其作用完全相同.

Hi,
Check this[^] post. Its doing exactly the same.

这篇关于如何根据值分组生成Sl.No的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！