You could also do it non-generically and unattractively and probably inefficiently like this (will select records 11-20):
SELECT TOP 10 * FROM
(SELECTTOP 10 * FROM
(SELECT TOP 20 * FROM division ORDER BY div_code ASC ) AS myTop20
ORDER BY div_code DESC) AS myTop10Desc
ORDER BY div_code ASC
Terri|||Thank you very much.|||tmorton.. that's just sexy!
No comments:
Post a Comment