在SQL中生成序列号 [英] generating Serial No in SQL
本文介绍了在SQL中生成序列号的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个有2列的表A
f1 f2
A 1
A 2
A 3
B 1
B 2
B 3
我希望以下列格式输出
Sl.No F1 F2
1 A 1
2 A 2
3 A 3
1 B 1
2 B 2
3 B 3
预付款
Saju
[edit]已添加代码块 - OriginalGriff [/ edit]
解决方案
尝试
SELECT f2 AS [Sl.No],f1 AS F1,f2 AS F2 FROM A
蛋糕..使用 RankingFunctions [ ^ ]
选择 Row_Number() Over ( Partition by f1 订单 按 f2) as [Sl.No],f1 as [F1],f2 as [F2] 来自 TableA
选择(rank() OVER ( ORDER BY [f2])) as SerialNo,f1,f2 来自 TableA
I have a table A with 2 columns
f1 f2
A 1
A 2
A 3
B 1
B 2
B 3
I want the out put in the below format
Sl.No F1 F2
1 A 1
2 A 2
3 A 3
1 B 1
2 B 2
3 B 3
Thanks in Advance
Saju
[edit]Code block added - OriginalGriff[/edit]
解决方案
Try
SELECT f2 AS [Sl.No], f1 AS F1, f2 AS F2 FROM A
Peice of cake.. Use RankingFunctions[^]
Select Row_Number() Over(Partition by f1 Order by f2) as [Sl.No],f1 as [F1],f2 as [F2] From TableA
select (rank() OVER(ORDER BY [f2])) as SerialNo,f1,f2 from TableA
这篇关于在SQL中生成序列号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文