Access查询前几条的top

写了一条查询语句select top 10 * from TableName order by id desc竟然把全部的查出来了,搞了半天不知道咋回事。后来问一下同事,跟我说要这样写才可以select * from (select top 10 * from TableName ) order by id desc

最近回复