在ASP中访问数据库时，如何只是把表中的最新的10条记录显示出来呢？比如：sql="select * from question where userneme='"&request("username")&"' order by id desc"，这样就把符合条件的记录都显示出来了，我想只是显示最新的10个记录，怎么写SQL查询语句呢？以前我用HPH+MYSQL是是这样表达的：sql="select * from question where userneme='"&request("username")&"' order by id desc limit 10"，但在MS SQL SERVER2000中不正确。请各位指点！多谢！
---------------------------------------------------------------
sql="select TOP 10 from question where userneme='"&request("username")&"' order by id desc
---------------------------------------------------------------
用TOP子句
---------------------------------------------------------------
sql ="select top 10 字段1,字段2 from question where username='" & request("username") & "' order by id desc"
---------------------------------------------------------------
top 10