Select from table

Question

Hello

Using Access mdb with OleDbRader (Access Database Engine) to select all:

"SELECT * FROM tabke WHERE clmn = 'blah'"

This might return 100 items, how can I use select to read from number 5 to 50, for example?

Possible?

Thank you all

Answer 1

Hi @StewartBW ,

Select the top 50 data and exclude the first four data.

SELECT * 
FROM (
    SELECT TOP 50 * 
    FROM tabke 
    WHERE clmn = 'blah' 
    ORDER BY some_column
) AS temp 
WHERE some_column NOT IN (
    SELECT TOP 4 some_column 
    FROM tabke 
    WHERE clmn = 'blah' 
    ORDER BY some_column
)

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.