Re: Finding a record's position when sorted

[Peter Brawley]

SQL Server has a Row_Number() func. MySQL does not. You can create one in a temp table eg

SET @ord=0;
CREATE TABLE temp
SELECT @ord:=@ord+1 AS ord, ...
FROM tbl
ORDER BY ...;

Then join to the temp table in your reproting query.

PB