答案是一个高手的,不是我的 谁的?我现在也不知道 如果侵犯了原作者的权利,还请见谅。特此声明。 答案如下: select top (y-x+1) * from (select top y * from tab order by ... ASC/DESC) order by ... DESC/ASC
ghxghx() :select top 10 * from ( select top 10 * from jbxx_zg order by zgbm ) order by zgbm 不好用啊!?语法错误
key为表中的关键字段,n是截取的次数,10 为每次截取的记录数试试看,我这里测试通过。 select top 10 * from table where key not in(select top 10*(n-1) key from table)
sorry!少写了一个,正确的为: select top 10 * from table a where a.key not in(select top 10*(n-1) b.key from table b)
select top (y-x+1) * from (select top y * from tab order by ... ASC/DESC) order by ... DESC/ASC什么意思啊?麻烦解释一下好吗? 另外语法好像不对,应该为: select top (y-x+1) * from (select top y * from tab order by ... ASC/DESC) as a order by ... DESC/ASC但是什么意思啊?
不知道结果对不对: select top 10 * from ( select top 10 * from jbxx_zg order by zgbm )aa order by aa.zgbm 上面的答案是取x-y条记录的
如果一定要求这么做。是不是可以这样 第一条 n = 1 select top 10 * from (select top n*10 from table order by key desc) 第二条 n = 2 select top 10 * from (select top n*10 from table order by key desc)
谁的?我现在也不知道
如果侵犯了原作者的权利,还请见谅。特此声明。
答案如下:
select top (y-x+1) * from (select top y * from tab order by ... ASC/DESC) order by ... DESC/ASC
from ( select top 10 * from jbxx_zg order by zgbm )
order by zgbm 不好用啊!?语法错误
select top 10 * from table
where key not in(select top 10*(n-1) key from table)
select top 10 * from table a
where a.key not in(select top 10*(n-1) b.key from table b)
另外语法好像不对,应该为:
select top (y-x+1) * from (select top y * from tab order by ... ASC/DESC) as a order by ... DESC/ASC但是什么意思啊?
select top 10 *
from ( select top 10 * from jbxx_zg order by zgbm )aa
order by aa.zgbm 上面的答案是取x-y条记录的
第一条 n = 1
select top 10 * from (select top n*10 from table order by key desc)
第二条 n = 2
select top 10 * from (select top n*10 from table order by key desc)
如果可行,确实是个好方法
ADO如何用啊?
我的目的是在浏览器端读取,但为了速度问题,所以不要一次性读到本地。
ADO应该可以的,但我不清楚是否需要把数据读到本地,还是在服务器上建立记录集?小冰块的答案很好,多谢!
事实上一次性读取得客户端的速度会比,分批读取块很多。你是不是要实现翻页的功能?