Adding a 'counter' to a query's output 1

[VickyC]

hello

Lets say I have SQL like...

SELECT qryVal.V1, qryVal.V2, qryVal.V3
FROM qryVal ...etc, that produces typical output like...

V1 V2 V3
12 42 29
51 23 99
...etc

What is the best way to add a field that starts at 1 and
increments by 1 for each row.

N V1 V2 V3
1 12 42 29
2 51 23 99
...etc

Thank you

 

[randy700]

Check the FAQs for this forum. A couple refer to this request.


Randy