Lucas.CTR.Heumanfaa.gov
Date: Wed Mar 28 2007 - 09:45:18 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Has anyone found a way to get a result set with the current row return
number in a select statement without using vars?

select concat('Test row ',currentreturnrownum()) as testdata , mytestdata
from mytestdatatable;

+------------------------+-------------------+
|Test row 1 | testdata |
|Test row 2 | testdata |
|Test row 3 | testdata |
|Test row 4 | testdata |
|Test row 5 | testdata |
|Test row 6 | testdata |
|Test row 7 | testdata |
|Test row 8 | testdata |
|Test row 9 | testdata |
+------------------------+-------------------+
(9 rows returned)

Wishing you the best you know you deserve,

______________________
Lucas Heuman
CM Web Developer
SRA International, Inc.
FAA, WJHTC/Bldg 300, 2nd Fl., H33
Atlantic City Int'l Airport, NJ 08405
Phone 609.485.5401

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]