本文介绍了想要创建序列号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我要生成序列号
例如
我有，
NID
-----
ABD90
BGJ89
HSA76
我想要，
ID NID
---------
1 ABD90
2 BGJ89
3 HSA76
我应该为这个结果运行什么代码?请帮帮我.
What code should I run for this outcome? Please help me.
推荐答案
既然你标记了SAS，那我就用SAS来回答.
Since you tagged SAS, I'll answer with SAS.
根据您的问题，从该输入中获取结果就像这样简单
Based on your question, getting that result from that input would be as simple as this
data result;
ID=_N_;
set input;
run;
或
proc sql;
select ID as monotonic()
,NID
from input
;
quit;
在纯 Oracle 中你会这样做
In pure Oracle you would do this
select rownum, NID
from input
但是，您可能希望在其中添加 ORDER BY，因为每次运行时您可能会得到不同的结果.
However you might want to throw on ORDER BY in there because you'll likely get different results every time you run that.
这篇关于想要创建序列号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！