1.
select abc, id
from a
limit 10000, 10;
2.
select abc, id
from a
limit 10 offset 10000;
3-1.
select q.abc, id
from (
select abc
from a
where 필요하면 작성....
order by 필요하면 작성...
limit 10000, 10
) q
join a
on q.abc = a.abc
;
3-2.
select q.abc, id
from a
join (
select abc
from a
where 필요하면 작성....
order by 필요하면 작성...
limit 10000, 10
) q
on q.abc = a.abc
;
3-3.
select q.abc, id
from a, (
select abc
from a
where 필요하면 작성....
order by 필요하면 작성...
limit 10000, 10
) q
where q.abc = a.abc
;