SQLServer: SELECT * FROM
(
SELECT TOP(PageSize) * FROM
(
SELECT TOP (PageSize * PageIndex) *
FROM Articles
ORDER BY id DESC
)
ORDER BY id ASC
)
ORDER BY id DESC Oracle:
select * from (
select rownum num,t1.*
from table t1 where fast=0
) where num>=intPosition and num<=intEndPosition
(
SELECT TOP(PageSize) * FROM
(
SELECT TOP (PageSize * PageIndex) *
FROM Articles
ORDER BY id DESC
)
ORDER BY id ASC
)
ORDER BY id DESC Oracle:
select * from (
select rownum num,t1.*
from table t1 where fast=0
) where num>=intPosition and num<=intEndPosition
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货