要创建序列号

本文介绍了要创建序列号的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我要生成序列号

例如

我有，

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.