9
Reply

Fetch records from sql server database table in parts

Suhani Mody

Suhani Mody

May 4 2011 8:57 AM
1.8k
Hi All,

I want to fetch records from a table in my sql server database in parts. Like, in one query I want to see first 1000 records, in next query next 1000 records. Likewise..

Is it possible with sql server ? I am using sql server 2008. While googling, I found LIMIT clause for mysql, but it does not work for sql server. Please help.

Answers (9)