T
txjtxj
Unregistered / Unconfirmed
GUEST, unregistred user!
一个简单的问题， 谁帮写一下，sql语句（从一张表中取第10条到25条记录）。
您正在使用一款已经过时的浏览器！部分功能不能正常使用。
请尝试升级或使用 其他浏览器。
请尝试升级或使用 其他浏览器。
C
Celestial dog
Unregistered / Unconfirmed
GUEST, unregistred user!
oracle:
select * from tablename
where rownum between 10 and 25
select * from tablename
where rownum between 10 and 25
T
txjtxj
Unregistered / Unconfirmed
GUEST, unregistred user!
不好意思，我没说完，我用的是mssql
B
bonip
Unregistered / Unconfirmed
GUEST, unregistred user!
sorry
F
fjnnz
Unregistered / Unconfirmed
GUEST, unregistred user!
你的表（TableName）中一定有一个主关键字（排序字段），假设为 KeyId
则
select Top 15 * from (select Top 25 * from TableName order by KeyId Asc) order by KeyId Desc
则
select Top 15 * from (select Top 25 * from TableName order by KeyId Asc) order by KeyId Desc
Z
zohzjf
Unregistered / Unconfirmed
GUEST, unregistred user!
select * from (select rownum id,pjid from piaoju where rownum<55) where id>15 and id<25
U
ugvanxk
Unregistered / Unconfirmed
GUEST, unregistred user!
同意 finnz
T
txjtxj
Unregistered / Unconfirmed
GUEST, unregistred user!
如果主关键字中间断开了，可不可以呢。
比如：10、11、12、14.....
中间没有13.或没有14.
比如：10、11、12、14.....
中间没有13.或没有14.
T
txjtxj
Unregistered / Unconfirmed
GUEST, unregistred user!
select Top 15 * from (select Top 25 * from TableName order by KeyId Asc) order by KeyId Desc
这句话我试了，但在order 附近有错误.
这句话我试了，但在order 附近有错误.
L
llh_lily
Unregistered / Unconfirmed
GUEST, unregistred user!
改为
select Top 15 *
from
(select Top 25 * from TableName order by KeyId Asc) as a
order by KeyId Desc 即可。若返回字段较多也可用如下语句：
select * from TableName
where KeyId in (select top 25 KeyId from TableName )
and KeyId not in (select top 9 KeyId from TableName )
select Top 15 *
from
(select Top 25 * from TableName order by KeyId Asc) as a
order by KeyId Desc 即可。若返回字段较多也可用如下语句：
select * from TableName
where KeyId in (select top 25 KeyId from TableName )
and KeyId not in (select top 9 KeyId from TableName )
0
0738
Unregistered / Unconfirmed
GUEST, unregistred user!
照llh_lily的作吧
T
txjtxj
Unregistered / Unconfirmed
GUEST, unregistred user!
select Top 15 *
from
(select Top 25 * from TableName order by KeyId Asc) as a
order by KeyId Desc
这句话写的不对，返回的值不正确
from
(select Top 25 * from TableName order by KeyId Asc) as a
order by KeyId Desc
这句话写的不对，返回的值不正确
L
llh_lily
Unregistered / Unconfirmed
GUEST, unregistred user!
to txjtxj:
是不是记录数不对，还是记录的排序方式不对，若记录数不对则换以下的语句：
select Top 16 *
from (select Top 25 * from TableName) as a
order by KeyId Desc
若是排序方式不满意，那你还是用这条语句：
select * from TableName
where KeyId in (select top 25 KeyId from TableName )
and KeyId not in (select top 9 KeyId from TableName )
是不是记录数不对，还是记录的排序方式不对，若记录数不对则换以下的语句：
select Top 16 *
from (select Top 25 * from TableName) as a
order by KeyId Desc
若是排序方式不满意，那你还是用这条语句：
select * from TableName
where KeyId in (select top 25 KeyId from TableName )
and KeyId not in (select top 9 KeyId from TableName )
T
T金花
Unregistered / Unconfirmed
GUEST, unregistred user!
select Top 16 *
from (select Top 25 * from TableName) as a
order by KeyId Desc
这句话返回的值根本就不对。
from (select Top 25 * from TableName) as a
order by KeyId Desc
这句话返回的值根本就不对。
V
V_Lucky
Unregistered / Unconfirmed
GUEST, unregistred user!
select * from
(
select Top 15 * from
(
select Top 25 * from TableName order by KeyId Asc
) order by KeyId Desc
)order by KeyId
(
select Top 15 * from
(
select Top 25 * from TableName order by KeyId Asc
) order by KeyId Desc
)order by KeyId
L
llh_lily
Unregistered / Unconfirmed
GUEST, unregistred user!
To T金花:
请指明是怎么个不对？[?]
请指明是怎么个不对？[?]
Similar threads
J
- 回复
- 3
- 查看
- 173
J