반응형
[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
반응형