There are 10 records in a table. How to extract the 5th to 8th data without using the id number?

kentotoro

There are 10 records in a table. How to extract the 5th to 8th data without using the id number?

zyzyzy22

Anyway, only 10 full reading, program processing

zyzyzy22

Only 10, full read, code processing

woodal

SQL Server: select top 4 * from (select top 8 * from table a where not exists (select top 4 * from table columns_A = a.columns_A))
Oracle: select * from table where rownum between 5 and 8
____________________________________
...
Probably that's it

373996077

select top m, n from XXX

qingzhub

A good solution to this problem with cursors is that they are not efficient. Is there anything better?

kalian2000

Read it out one by one with DataReader ..

or

The data is put into a DataTable, and then the data in the DataTable is fetched ..

Comments are for reference only.

linhanerror

Take 8 heads, in reverse row Take 3 heads (do not reverse up with you)
^^^^^^^^^^^^^^^^^
Simple questions are easy to do ~! :)

lqqicq

First, top order 8 and then top 4, then it ’s OK. Do you still need to write SQL?

dakaka

Set the logical page size, 4 records per page, just take the record on page 2