LazyDreamy

이중 order 를 사용해서 mysql 의 limit 와 유사하게 구현

SELECT * FROM (
    SELECT TOP x * FROM (
        SELECT TOP y fields
        FROM table
        WHERE conditions
        ORDER BY table.field  ASC) as foo
    ORDER by field DESC) as bar
ORDER by field ASC

x = rows
y = rows + offset