Let´s say that I have the following simple SELECT statement:
SELECT first, id FROM customers ORDER BY first
This would result in something like this:
Charles C1001
John A3021
Kevin F2016
Paul N4312
Steve J0087
Is it possible to include a "field" in the SELECT such that it represents the position of each record?
For example, I need to get a result like this:
1 Charles C1001
2 John A3021
3 Kevin F2016
4 Paul N4312
5 Steve J0087
Respectfully,
Jorge Maldonado