开发者

How do I create a query that returns a range of rows from MS ACCESS?

Is there anyway to do a limit in MS Access, like I would using M开发者_如何学CySQL.

For example:

select * from cars limit 10,20

I'm implementing the database access in C#.


There is no direct equivalent to MySQL's 2-argument LIMIT in MS Access.

There is TOP x:

select TOP 20 * from cars 

See: In Access97 SQL how do I return a range of rows?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜