Subject Record numbering
Author jasajona
How to write select that gives field of selected record number. I have
table just from one field "SomeField" how to get result:


RecNo SomeField
----- --------------
1 sdferfer
2 ertertt dfgdfg
3 df ;dlfklee
...

I do not want to use generators, I need every time to start from 1