CODEWITHSUNDEEP
ms-access
user1376389
user1376389

Reputation: 35

Ms access Select query with limit options

i have a query like : select id, name from table_name where id is not null limit 10, 20 for mysql; how can i get 10 to 20 records from table in ms access? i know there is no limit keyword and how do i use TOP keyword?

Upvotes: 2

Views: 4246

Answers (1)

Nick
Nick

Reputation: 1128

SELECT * FROM 
    (SELECT TOP 11 *  FROM 
        (SELECT TOP 20 * FROM table_name ORDER BY 1) 
    ORDER BY 1 DESC)
ORDER BY 1

Upvotes: 4

Related Questions