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

 

저작자표시 (새창열림)