-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
SELECT * FROM t1;

SELECT @rownum:=@rownum+1 rownum, t1.* FROM (SELECT @rownum:=0) r, t1;

SELECT * FROM (SELECT @rownum:=@rownum+1 row, t1.* FROM (SELECT @rownum:=0) x, t1) y WHERE row % 2 = 1;
