SQL Server （Transact-SQL）で LIMIT OFFSETする方法

SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY score DESC, speaker) AS rownum, speaker, track, score FROM SpeakerStats) AS D WHERE rownum BETWEEN 4 AND 6 ORDER BY score DESC, speaker

via msdn.microsoft.com

副問い合わせで行番号を振って、それで絞り込む
なんて使えない

via ひひーん！