1. rownum 생성

SELECT @ROWNUM, A.*
FROM product A, (SELECT @ROWNUM:=0) R
;

출처:

• https://developer-jjun.tistory.com/23
• https://its-easy.tistory.com/18

2. limit

01. limit로 추출

// 1. 5개 가져오기  
SELECT * FROM product LIMIT 5;  
  
// 2. LIMIT (시작점, 갯수) (1번째부터 5개 추출. 첫번째 파라미터는 0 부터 시작)  
SELECT * FROM product LIMIT 0, 5;  

출처: https://zorba91.tistory.com/178

02. limit + rownum 추출

SELECT @ROWNUM:=@ROWNUM+1 as rownum, A.*
FROM product A, (SELECT @ROWNUM:=0) R
limit 0, 5
;

SELECT @ROWNUM:=@ROWNUM+1 as rownum, A.*
FROM product A, (SELECT @ROWNUM:=5) R
limit 5, 5
;

03. 응용

- rownum 사용

SELECT @ROWNUM:=@ROWNUM+1 as rownum, A.*
FROM product A, (SELECT @ROWNUM:=0) R
order by unitPrice
limit 0, 5
;

SELECT @ROWNUM:=@ROWNUM+1 as rownum, A.*
FROM product A, (SELECT @ROWNUM:=5) R
order by unitPrice
limit 5, 5
;

- limit 사용

select * from product 
order by unitPrice
limit 0, 5; 

select * from product 
order by unitPrice
limit 5, 5;