SQL语句选取倒数第2行到倒数第5行怎么写?
如题。怎么选取倒数第2行到倒数第5行的数据,SQL语句?
[解决办法]
- SQL code
select top(4) * from (select top 5 * from user_info order by id desc) as t order by id asc
发布时间: 2012-03-11 18:15:38 作者: rapoo
SQL语句选取倒数第2行到倒数第5行怎么写?
如题。怎么选取倒数第2行到倒数第5行的数据,SQL语句?
[解决办法]
select top(4) * from (select top 5 * from user_info order by id desc) as t order by id asc