SELECT TOP(100) * FROM dbo.users EXLUDE TOP(50) WHERE users.name = 'John'
Is there something like my code above? Essentially, I am attempting to NOT select the first 50 records that return with the name John, but the second set of 50 (51-100). I'd like to change this range as needed (to anything from 51-100 to 879-1013, not literal).
The record identity number will not help as John, then Sally, then Kate, then another John may have signed up, so I don't believe that
WHERE BETWEEN will work....