|
| | | New Member
Group: Forum Members
Last Login: Sunday, August 31, 2008 5:46 PM
Posts: 3, Visits: 27 |
| You could also use between. Something along the lines of
SELECT TOP 11 * FROM (SELECT row_number() OVER (ORDER BY id desc) AS rownum, column1, column2, etc FROM tablename) AS A WHERE A.rownum BETWEEN (2) AND (11)
h4ck-y0u.org
|
| |
|
|