查询语句 INFO表里面有个SORT字段,是用来分类的 要想用top取得SORT='news'中的第11条到第15条数据该怎么写sql语句 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 5* from(select top 15* from info where sort='new')torder by id desc ---sql 2005可以这样select top 15 * from info order idexceptselect top 10* from into id select top 5 * from (select top 15 * from INFOwhere SORT='news') as a order by id desc--就是分页嘛 select * from (select ROW_NUMBER()over(order by getdate())rn,* from INFO where SORT='news')a where rn between 11 and 15 ---不应该从时间上去取值的,应从id取select * from (select row_number() over(order by id)rn,* from intowhere sort='news')twhere rn between 11 and 15 --不好意思上边表名写错了---不应该从时间上去取值的,应从id取select * from (select row_number() over(order by id)rn,* from intowhere sort='news')twhere rn between 11 and 15 --不好意思上边表名写错了---不应该从时间上去取值的,应从id取select * from (select row_number() over(order by id)rn,* from infowhere sort='news')twhere rn between 11 and 15 sql 日/月/年 时:分 日期函数 当数据库很庞大时我应该怎么维护 存储过程和自定义函数的问题:为什么会同时存在?去掉一个不行吗? 二个vb调用sql数据库的connectString和datetime数据类型问题,望大侠指点迷津~~~ SQL过滤问题 系统某月各星期的数据,再加100分,在线等. 要修改记录,其中有一个字段值可以为null,怎样给这个字段设一个值 sql server 2000数据库不能写入两个以上的汉字! 如何定时执行指定的存储过程? 怎样在SQLServer的存储过程中处理图形数据 SQL2005 行列轉換 关于两张表联合查询的问题
select top 5* from
(select top 15* from info
where sort='new')t
order by id desc
select top 15 * from info order id
except
select top 10* from into id
select top 5 * from (select top 15 * from INFO
where SORT='news') as a order by id desc--就是分页嘛
select * from (select ROW_NUMBER()over(order by getdate())rn,* from INFO where SORT='news')a where rn between 11 and 15
select * from
(select row_number() over(order by id)rn,* from into
where sort='news')t
where rn between 11 and 15
---不应该从时间上去取值的,应从id取
select * from
(select row_number() over(order by id)rn,* from into
where sort='news')t
where rn between 11 and 15
---不应该从时间上去取值的,应从id取
select * from
(select row_number() over(order by id)rn,* from info
where sort='news')t
where rn between 11 and 15