Try below:
Select * FROM YourTable WHERE ID BETWEEN 100 AND 140
OR
Select * FROM YourTable WHERE ID > 100 AND ID < 140
0
solved Sql query to select ID from 100 to 140 [duplicate]
Try below:
Select * FROM YourTable WHERE ID BETWEEN 100 AND 140
OR
Select * FROM YourTable WHERE ID > 100 AND ID < 140
0
solved Sql query to select ID from 100 to 140 [duplicate]