Query discontinuous data

The general query can be as follows:

Code:

1. Select*FromTbxxWhereIDBetween5And10

Or others, but there is a condition that the ID must be continuous.

Code:

1. Select*FromTbsickinfo

Then I want to query 10 pieces of data between 20 and 300.

Code:

1. Select Top10 *FromTbsickinfoWhereSidNot In(Select Top20 SidFromTbsickinfo)

After reading this figure, we will find that 2010092414 will jump to 2010092515, and this will also apply if some data is deleted in the middle.

Code:

1. Select Top5 *FromTbsickinfoWhereSidNot In(Select Top14 SidFromTbsickinfo)

Not in first removes the first 14 records and then queries the first 5 Records. That is, to query 15th to 19th data records.