DB/MySQL
MySQL ROWNUM
냐옴
2013. 12. 3. 18:42
SELECT
(@RNUM := @RNUM + 1) AS RNUM
, B.*
FROM
(SELECT @RNUM := 0) A,
'TABLE_NAME' B
LIMIT 25 OFFSET 0