oracle - Want to create serial numbers -


i want generate serial no.s

e.g.

i have,

nid -----  abd90 bgj89 hsa76 

and want,

id nid --------- 1  abd90  2  bgj89 3  hsa76 

what code should run outcome? please me.

since tagged sas, i'll answer sas.

based on question, getting result input simple this

data result;   id=_n_;   set input; run; 

or

proc sql;   select id monotonic()         ,nid   input   ; quit; 

in pure oracle this

select rownum, nid input 

however might want throw on order in there because you'll different results every time run that.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -