I want to use paging and I don't want to get so many records.
But if I use select top (100) for example, how will I get the rest of the records, split in 100 per each select query. I have seen example like this
SELECT TOP (100) OrderDate, ShipName FROM orders WHERE orderID NOT IN (SELECT TOP OFFSET OrderID FROM orders)
. But I have read and tried that Offset doesn't work in SQL Server. Is there anything else I can do?