oracle rownum 구현하기

[mysql-tip]oracle rownum 구현하기

 

 

SELECT @RNUM:=@RNUM+1 AS ROWNUM FROM (SELECT @RNUM:=0) R

SELECT @RNUM:=@RNUM+1 as ROWNUM , A.*
FROM (SELECT @RNUM:=0) R,
   (SELECT 출력할컬럼    FROM 테이블명
    WHERE 조건처리
    ORDER BY 역순정렬을위한컬럼 DESC) AS A

LIMIT 10