[sql] limit offset

Select * from 테이블명 orders LIMIT A B;

B : B번째 row부터 출력

A : A개의 행 출력

 

select
	member0_.member_id as member_i1_0_, member0_.age as age2_0_, member0_.team_id as team_id4_0_, member0_.username as username3_0_ 
from 
	member member0_ 
where 
	member0_.age=10 
order by 
	member0_.username desc limit 3 offset 1;

1번째 row부터 3개의 행을 출력하라는 것 (row의 첫번째 index는 0이다.)