请问ACCESS数据库如何按索引查找
choge 2016-01-03 07:51:06 通过ADOQuery连接ACCESS数据库,库里有一个字段ID,已建立索引,索引名为indexID,请问如何写SQL语句
按字段查找:sql = "select * from Table order by ID desc"; 按索引怎么写呢?参考别人的写法如下会报错
sql = "select * from Table order by indexID desc";
sql = "select * with index( indexID) from Table order by ID desc";
sql = "select * from Table order byindex( indexID) desc"; 均报错
请大家赐教