Hi, is there some trick to get the row number of a query starting with
1, just using a select?

row#, field1
1, a
2, b
3, c
4, d
... and so on

Regards,

Fabiano.