With ListRec As( SELECT ROW_NUMBER() OVER(ORDER BY field1,field2) AS rownum,field1,field2,field3 FROM [MyTable] WHERE MyCondition ) SELECT * FROM ListRec WHERE rownum > 90 and rownum <= 100
SELECT TOP 10 field1,field2,field3 FROM [MyTable] WHERE (field1 NOT IN (SELECT TOP 90 field1 FROM [MyTable] WHERE MyCondition ORDER BY field1,field2)) And MyCondition ORDER BY field1,field2
wrote:With ListRec As( SELECT ROW_NUMBER() OVER(ORDER BY field1,field2) AS rownum,field1,field2,field3 FROM [MyTable] WHERE MyCondition ) SELECT * FROM ListRec WHERE rownum > 90 and rownum <= 100
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)