I thought LIMIT was a proprietary vendor extension, not a standard clause.

You could probably do something like...

SELECT * FROM (
SELECT TOP 5 -- actually bottom five of the top fifteen (seek 10)
    *
FROM
    (
       SELECT TOP 15
          *
       FROM
          Table
       ORDER BY
          Field
    )
ORDER BY
    Field DESC
)
ORDER BY Field -- fix order