[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
