在ASP access中如用select 语句返回数据库中前几条记录

在ASP access中如用select 语句返回数据库中前几条记录在ASP access中如用select 语句返回数据库中前几条记录select top 10 * from table前10条记录select top N * from table(N代表你想返回的数目)select top （n条） * from （table表名）topselect top N * from tablenameselect top N * from table where 条件 order by id desc/ascselect top [N] * from [table] [where 条件] order by 想要排列的字段 asc/descselect top N * from table where 条件 order by id desc/asc来晚了哦