SqlServer & Limit

[zampa28]

Esiste in SqlServer una funzione simile alla clausola Limit X,Y di MySql?

[riccardone]

la funzione TOP potrebbe fare al caso tuo...

http://troels.arvin.dk/db/rdbms/#select-limit
http://troels.arvin.dk/db/rdbms/#select-limit-offset

[zampa28]

Perfetto!

SELECT * FROM (
  SELECT TOP n * FROM (
    SELECT TOP z columns      -- (z=n+skip)
    FROM tablename
    ORDER BY key ASC
  ) AS FOO ORDER BY key DESC -- ('FOO' may be anything)
) AS BAR ORDER BY key ASC    -- ('BAR' may be anything)

grazie !