quote:

---

Originally posted by lionofdezert

SQL Server 2012 provides more better solution
SELECT *
FROM MyTable
ORDER BY TableColumn
FETCH NEXT 10 ROWS ONLY;

In prior vesions, you can use CTE (Common Table Expression) to achive this functionality.

;WITH CTE (SELECT *, ROW_NUMBER() OVER (ORDER BY TableColumn)AS RowNum FROM MyTable)
SELECT * FROM CTE WHWERE RowNum >=1 and RowNum<=11

--------------------------
http://connectsql.com/

---