select top 50 * from (select top 100 * from [user] order by userid) aa order by userid既然倒续了,那你就反过来么~~~去掉DESC~
select top 50 * from (select top 100 * from [user] order by userid) aa order by userid 兩個select的order by 要一致
不对啊,用 select top 50 * from (select top 100 * from [user] order by userid) aa order by userid取到的是0——50条数据啊,不是51——100条啊!
SELECT * FROM(select top 50 * from (select top 100 * from [user] order by userid) aa order by userid DESC) ORDER BY userid好象麻烦了点~~~~不过应该说有更简单的方法~~没仔细去想~~~~
上面有个语法错误SELECT * FROM(select top 50 * from (select top 100 * from [user] order by userid) aa order by userid DESC) bb ORDER BY userid
(select top 100 * from [user] order by userid) aa
order by userid既然倒续了,那你就反过来么~~~去掉DESC~
(select top 100 * from [user] order by userid) aa
order by userid
兩個select的order by 要一致
select top 50 * from
(select top 100 * from [user] order by userid) aa
order by userid取到的是0——50条数据啊,不是51——100条啊!
(select top 100 * from [user] order by userid) aa
order by userid DESC) ORDER BY userid好象麻烦了点~~~~不过应该说有更简单的方法~~没仔细去想~~~~
(select top 100 * from [user] order by userid) aa
order by userid DESC) bb ORDER BY userid
繁是繁了点,不过效果是达到了,有没有更好的方法呢?