How to select data from different area of the data table

Question

User-218090889 posted

Hello friends,

I have a big database that I usually select data from the data table 1 row at a time.
I have been using the below line of code to select from TOP, that is TOP 1

 using (SqlCommand sqlCmd = new SqlCommand("SELECT TOP (1) col1, col2 FROM table1 ", con))

but I wish to select 1 row at a time from the middle part of the data table. And also from the lower part of the data table at different time.

Please can any one suggest very good way to achieve my objective.