limit 종류

 

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

;