What is equivalent of Oracle rownum in db2 ?
for eg.
Create tabe dept
(
deptno number(8)
deptname char(10)
loc char(10)
seq_no nummber(8)
)
insert into dept(deptno,deptname,loc,seq_no)
select dept_no,
deptname,
loc,
rownum
from table dept_region
My question is how do I write above rownum in db2.
for eg.
Create tabe dept
(
deptno number(8)
deptname char(10)
loc char(10)
seq_no nummber(8)
)
insert into dept(deptno,deptname,loc,seq_no)
select dept_no,
deptname,
loc,
rownum
from table dept_region
My question is how do I write above rownum in db2.