查人人中国名人网贝尔机器人教育培训:SQL语句的问题!
来源：百度文库 编辑：查人人中国名人网 时间：2024/05/06 19:05:04
我从别的地方知道了如果想从第4条记录开始显示数据库中的内容应该是:
select * from myart where not exists (select top 3 * from myart order by subtime desc)
可是我用了之后却显示为空,为什么呢?
select * from myart where not exists (select top 3 * from myart order by subtime desc)
可是我用了之后却显示为空,为什么呢?
select * from myart where not exists (select top 3 * from myart order by subtime desc)
------------------------------
select * from myart where fid not in (select top 3 fid from myart order by subtime desc)
这样应该就可以了
not exists (select top 3 * from myart order by subtime desc)
条件不真,当然没有数据了
试试:
select @n=count(*) from myart
select * from
(select top @n-3 *
from myart order by subtime desc)
order by subtime asc