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