Simple Query

[shultz]

Is it possible to return rows from a certain number to certain number.

For example,
I give a SQL Statement as
Select * from tblTest

which gives me all the entries. Now I want to select the records from entry 20 to entry 30. Is it possible??

I know the statement

Select top 10 * from tblTest

gives me the first 10 records. But I want to do it from 10 to 20 etc.

Thanks in advance ..!!

 

[mukund]

Hi Shultz,
I have given the following query based on the Northwind database, you replace the tablename and columns with appropriate names.


select Top 10 * from Orders
Where OrderID Not In
(Select Top 10 OrderID from Orders Order By OrderID)
Order By OrderId


-Mukund.

 

[shultz]

hello mukund..

I think I was not clear...

I'm want something like for example.. tek-tips site.. where you display 10 entries at a time and on the next click you show the next 10 entries..

is it possible something like that in SQL Server. I mean I want to pass the number of records to fetch and from which record number..

any ideas??

thanks a lot

 

[tlbroadbent]

Check the following links.

Managing Result Set Paging:

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

Paging: Use ADO, getrows, or a Stored Procedure?

http://www.15seconds.com/issue/010308.htm

Paging through Records using a Stored Procedure:

http://www.aspfaqs.com/webtech/062899-1.shtml

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.