Say I have the following SQL statement:
SELECT a, b, c FROM t1 ORDER BY a; Is there a function or special system label I can use that would generate a sequence number in the returning result set? Example: SELECT a, b, c, SOMELABEL as order FROM t1 ORDER BY a; Result: a b c order --------------------- Aa bb cc 1 A1 bb cc 2 A2 bb cc 3 Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu <http://webservices.uiuc.edu/>
