Database is known for the ID of a data, how to query the next data and the ID is different

Database is known for the ID of a data, how to query the next data and the ID is different

First ID is known, if you get the "1001", the data ID of the next bar may be the same, there may be different, how to query? If you query directly

"SELECT * from table name where column name id= ' 1001 '"

You can only query a single piece of data, add "Top 2", and there will be only one piece of data. Can you directly query the data below this data?

"SELECT * from table name where column name id> ' 1001 ' Order by column name ID"

This will query the data larger than gaiid, as long as the next one, plus "top 1" on the line

"SELECT top 1 * from table name where column name id> ' 1001 ' Order by column name ID"

Database is known for the ID of a data, how to query the next data and the ID is different