Eine Einführung in

SQL

return a sequential record count for all records returned

SQLite
this should be simple - I would like to get a consecutive numbering count/id for each record returned from a query: eg: select * from tablex gives multiple rows like:
field1, field2, field3, ...
field1, field2, field3, ...
field1, field2, field3, ...
What I want is:
1, field1, field2, field3, ...
2, field1, field2, field3, ...
3, field1, field2, field3, ...
4, field1, field2, field3, ...


Specific to SQLite
none