I want t present a list from a table which contains a rownumber, see
example.
I thought this is very basic. But I cannot find out how

How do I handle this ?

select FLD1 from TABLE1

AA
BB
CC
XX

I want to present it as:


1 AA
2 BB
3 CC
4 XX


Another problem I have is how to pass a value from a previous selected
record to the current record, when selecting from a table.
I think it is the some problem I have as as I mention above.

I'm using Oracle RDB for OpenVMS

Please post a reply with your comments or send me mail.

Thanks in advance,

Peter Grevel