generating sequence number
Posted
by stackoverflowuser
on Stack Overflow
See other posts from Stack Overflow
or by stackoverflowuser
Published on 2010-04-28T19:02:23Z
Indexed on
2010/04/28
19:07 UTC
Read the original article
Hit count: 317
Hi
Based on following TableA
Data
--------
Dummy1
Dummy2
Dummy3
.
.
DummyN
is there a way to generate sequence number while selecting rows from the table.
something like select sequence() as ID,* from Data
that will give
ID Data
---------
1 Dummy1
2 Dummy2
3 Dummy3
....
N DummyN
Thanks.
© Stack Overflow or respective owner