--按降序排 select top 100 * from tblename order by ID desc
select top 100 * from tblename order by ID desc
呵呵 终于找到一个一样菜的人了 , 大哥 是这个 放心大胆的用吧select top 100 * from tblename order by ID desc
select top 100 * from tblename where 条件 order by ID desc
select top n * from table order by id desc
--按降序排 select top 100 * from tblename order by ID desc --按升序排 select * from (select top 100 * from table order by ID desc) a order by ID
小弟想对数据表的最后(按ID排序)的n行记录进行处理,比如从最后100行里select出合适的数据,如何通过一SQL语句实现啊??各位大虾帮帮忙吧!! 在最后100行里再找出符合条件的数据:若你的表的数据记录中ID已经是降序的: select * from 表 where id in (select top 100 id from 表 order by id) and 条件若你的表的数据记录中ID已经是升序的: select * from 表 where id in (select top 100 id from 表 order by id desc) and 条件
select top n * from table order by id desc 简单吧
select top n * from t order by id desc 降序 或者select top n * from t where in (selet top * from t order by id desc)升序
掉了一个子,应该是, select top n * from t where ( select top n * from t order by id desc)升序
select top 100 * from tblename order by ID desc
大哥
是这个 放心大胆的用吧select top 100 * from tblename order by ID desc
select top 100 * from tblename order by ID desc
--按升序排
select * from (select top 100 * from table order by ID desc) a order by ID
在最后100行里再找出符合条件的数据:若你的表的数据记录中ID已经是降序的:
select * from 表 where id in (select top 100 id from 表 order by id) and 条件若你的表的数据记录中ID已经是升序的:
select * from 表 where id in (select top 100 id from 表 order by id desc) and 条件
简单吧
或者select top n * from t where in (selet top * from t order by id desc)升序
select top n * from t where ( select top n * from t order by id desc)升序