El contrario a Select Top 10

[Beakdan]

Si usas SQL Server 2005, usa una combinación de subquery o CTE con ROW_NUMBER(). Sería algo así:

Código:

WITH FromRow(rn, field1, field2,..., fieldn) AS (
   SELECT ROW_NUMBER() OVER(ORDER BY field1, field2, ...),
           field1,
           field2,
           ...,
           fieldn
   FROM    table
   WHERE   conditions
)
SELECT  field1, field2,..., fieldn
FROM    FromRow
WHERE   rn >= 11