想要创建序列号

2022-01-08 00:00:00 numbers sequence sas oracle

我要生成序列号

例如

我有，

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.

相关文章