SQL_OFFSET, FETCH

SELECT userID,name, birthYear FROM userTBL
	ORDER BY birthYear


	SELECT userID,name, birthYear FROM userTBL
	ORDER BY birthYear
	OFFSET 4 ROWS; -- 4줄을 뛰어넘음, OFFSET은 반드시 ORDER BY절을 사용후 적용해야한다.

 

 

SELECT userID,name, birthYear FROM userTBL
ORDER BY birthYear
OFFSET 4 ROWS
FETCH NEXT 3 ROWS ONLY; -- 출력될 행의 수를 지정