I would like to generate sequence number in SQL command, something like this SELECT rownumber, field1, field2, ... FORM tablea ..

I would like thar the rownumber start with 1 until the last number of the record