Dear All

sorry many questions,
if there is a function ROWNUM in oracle (no serial record) if the firebird what functions the same



Example



Table AA (1 Field)

CODE_CD

110

112

131

108

145



SELECT ROWNUM no, CUS_CD FROM AA

NO CUS_CD

1 110

2 112

3 131

4 108

5 145





SELECT ROWNUM no, CUS_CD FROM ( SELECT * FROM AA ORDER BY CUS_CD)

NO CUS_CD

1 108

2 110

3 112

4 131

5 145



Thanks






===============================================================================================
This e-mail transmission is intended solely for the ordinary user of the e-mail address
to which it was addressed. It may contain legally privileged and/or confidential information.
If you have received this e-mail in error or are not an intended recipient please inform
the sender with-out delay and delete this e-mail, attachments and possible copies immediately.
The unauthorized use, disclosure, distribution and/or copying of this e-mail or any information
it contains is prohibited

[Non-text portions of this message have been removed]