This was the solution I was looking for. Thanks for helping though.
SELECT doesntmatterwhat
FROM whatever
ORDER BY 1
OFFSET 3 ROWS
FETCH FIRST 2 ROWS ONLY;
1
Matt
On
SELECT TOP 2 FROM (
SELECT TOP 3 doesntmatterwhat
FROM whatever
) a
ORDER BY doesntmatterwhat
Not using TOP
SELECT n.doesntmatterwhat
FROM (SELECT n.doesntmatterwhat, row_number() OVER (ORDER BY date DESC) AS sequence
FROM whatever n
) n
WHERE n.sequence>= 2 AND n.sequence<= 3;
This was the solution I was looking for. Thanks for helping though.