如何查询数据库倒数第二个字段
我现在想随时可以取出数据库中匹配ID的倒数某行数据，我写了个语句想查询倒是第二行的，不行，大家帮我看下
(select top 1 * from User_Train_Info where ID='85' and 状态='左手' order by AutoID desc) -1
[解决办法]
select top 1 * from (select top 2 * from User_Train_Info where ID='85' and 状态='左手' order by AutoID desc) order by AutoID
