我想取出数据库中前10条记录中的后5条，sql语句在写？

[websterjt]

select top 5 from table where id not in(select top 5 from a) a
有人告诉我这样写，但是报错误
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'

ODBC driver does not support the requested properties.

/nnd/2.asp，行14


我用的是asp+access！

[itzhiren]

select top 5 from table a where id not in(select top 5 from a)

[intereye]

恩~~~不错~~~

[an_wl]

支持……

[holoon]

就是这个方法啊

[websterjt]

select Top 5 * From news Where newsid not in (select Top 5 newsid From news) order by newsid desc

我换了种方法，成功了，上面那种我死活读不出来！