Hi all,
Is there a sql function or any workaround to display a serial number
along with other columns (with sql query)?

for example,

SrNo Name Phone
1 Abc 9848382
2 cde 5837273
3 efg 5478457

I searched through the net and found MS Sql server has something like this

select ROW_NUMBER()OVER(ORDERBY ColumnName1) AsSrNo

I just want to know whether anything like this is available in firebird.

Thanks in advance,
Jaison Joseph


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