At times you want to do something like

%%prettify 
{{{
sql> SELECT column FROM table WHERE condition LIMIT 100000,10
}}}
/%


to offset the selection of ten items by 100k items.  This will be very slow as it will fetch all the items and then discard the first 100k.  The proper way to do it is

%%prettify 
{{{
sql> SELECT column FROM table WHERE condition AND primary_key >= 100000 LIMIT 10
}}}
/%


----
[SQL | CategoryComputing.DB.SQL]