top 5 like statment 1

[kyriakos70]

Hello,
I want a statment to work like top 5 but not only for the first records but for a page of records eg from record 5 to 10, I have used this but gave me an error :

'SELECT TOP 5 * FROM scan WHERE id NOT IN (SELECT TOP 4 * id FROM scan Where id like aaaid))'

also would like to have a parameter to view particular records in the range.

Thank you
Kyriakos

 

[Crowley16]

yeah, your best bet for doing this would be to use the row_number function and then use where to limit the results into pages...

--------------------
Procrastinate Now!

 

[kyriakos70]

I found this is it correct? I mean there must be something else like between etc., can you give me an example about my query, more simple?
USE AdventureWorks2008R2;

GO
WITH OrderedOrders AS
(
    SELECT SalesOrderID, OrderDate,
    ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
    FROM Sales.SalesOrderHeader 
) 
SELECT * 
FROM OrderedOrders 
WHERE RowNumber BETWEEN 50 AND 60;

thank you
Kyriakos