K, I'm going to throw a wrench in the works and add a couple options.
http://en.wikipedia.org/wiki/Select_(SQL)#FETCH_FIRST_clause
So, to recap:
Option i: SKIPPING x TAKING y SELECT ... FROM ... WHERE ... ORDER BY ...
Option ii: SKIP x TAKE y SELECT ... FROM ... WHERE ... ORDER BY ...
Option iii: SELECT ... FROM ... WHERE ... ORDER BY ... SKIP x TAKE y
Option iv: SELECT ... FROM ... WHERE ... ORDER BY ... SKIPPING x TAKING y
Option v: SELECT FIRST x SKIP y ... FROM ... WHERE ... ORDER BY ...
Option vi: SELECT TOP x SKIP y ... FROM ... WHERE ... ORDER BY ...
Patrick Earl
