Home > MSSQL > Limit tag in MsSQL 2005

Limit tag in MsSQL 2005

April 23, 2009 ppshein Leave a comment Go to comments

Hope everybody knows about limit tag MsSql 2005. I feel that’s cool and can reduce the load of SQL query just like mySQL. It’s kinda simple to use this tag.

SELECT * FROM myTable limit 1,10

If we write so, the sql will return starting from the first record, and plus 10 record in the recordset of myTable.

SELECT * FROM myTable limit 20,40

If we write so, the sql will return starting from the 20th and plus 10 record of myTable. How.? It’s easy, isn’t it?

Categories: MSSQL Tags: , ,
  1. No comments yet.
  1. No trackbacks yet.
You must be logged in to post a comment.