SELECT (CASE WHEN ISNULL(@pos) THEN @pos := 0 ELSE (@pos := @pos + 1) END) FROM user_tabs ORDER BY pos