how to get specific set of records in sql server
Say I have 50 records in my table,(unique id is auto increment from 1 to 50) how do I retrieve records 10 to 30 using a sql query
select * from yourTable where yourIdColumn between 10 and 30
Replace yourTable with your table's name, and yourIdColumn with the name of your unique id field.
SELECT columnlist FROM yourTable WHERE IDColumn BETWEEN 10 AND 30