Record Number query

[nommy]

Hi,

Is there any sql query which can retrieve records from a
table such that in the result the first field displays the
record number.

For Example:- There is a table which contains over 1000
records. Now running a query which displays all the
records such that the first field should display the
record numbers
Plz reply ASAP

Thanks,
Nommy.