MariaDB ROWNUM

■ MySQL의 오라클 ROWNUM 효과처럼 순서 붙이기

SELECT (@ROWNUM := @ROWNUM + 1) RNUM
     , X.A
  FROM (
			SELECT '1' AS A UNION ALL
			SELECT '2' AS A UNION ALL
			SELECT '3' AS A UNION ALL
			SELECT '4' AS A UNION ALL
			SELECT '5' AS A 
       ) 										AS X
     , (SELECT @ROWNUM := -1) 			AS Y
-- 결과 : 시작을 -1으로 하면 결과(RNUM)는 0부터 시작됨
RNUM   A
0      1
1      2
2      3
3      4
4      5

SELECT (@ROWNUM := @ROWNUM + 1) RNUM
     , X.A
  FROM (
			SELECT '1' AS A UNION ALL
			SELECT '2' AS A UNION ALL
			SELECT '3' AS A UNION ALL
			SELECT '4' AS A UNION ALL
			SELECT '5' AS A 
       ) 										AS X
     , (SELECT @ROWNUM := 0) 			AS Y
-- 결과 : 시작을 0으로 하면 결과(RNUM)는 1부터 시작됨
RNUM   A
1      1
2      2
3      3
4      4
5      5