SQL语句的问题!

来源：百度知道 编辑：UC知道 时间：2024/05/10 20:06:00
我从别的地方知道了如果想从第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 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