select语句问题,查询区间语句问题!【高手进】【高悬赏】

发布网友 发布时间：2022-04-14 14:08

我来回答

共4个回答

热心网友 时间：2022-04-14 15:37

select * from (select top 30 * from article where item=39 order by r_date desc) a where a.id not in (select top 15 * from article where item=39 order by r_date asc)

-------------------------------------------------
什么意思?? 不能用吗??按你的意思应该这样能实用的呢
-------------------------------------------------------------
sqltext="Select top 15 * from article where item=39 order by r_date desc"
这个换成
sqltext="select * from (select top 30 * from article where item=39 order by r_date desc) a where a.id not in (select top 15 * from article where item=39 order by r_date asc) "

热心网友 时间：2022-04-14 16:55

不矢你是否用的oracle
可以这样写
select * from table where rownum >=15 and rownum<=30;

热心网友 时间：2022-04-14 18:30

Select * from article where id between 16 and 30 and item=39 order by r_date desc

试下行不

热心网友 时间：2022-04-14 20:21

select top 15 * from
(select top 30 * from article order by id) a
order by id desc