I need to include an incremental number (1,2,3,4,5,6.....) column in my query, how can i go about this? I cant add an autonumber column or anything to the table, i just need to bring up a number column in my query. I know you can bring up a column of random numbers by doing "SELECT RAND(), blah, blah FROM blah" is there an increment function? its on a MySQL server if that matters..
thanks
thanks