降序不起作用

Question

这个存储过程不执行数据的降序，我不知道为什么！

BEGIN 
    SET nocount ON; 
    WITH ordereddata 
         AS (SELECT *, 
                    rn = Row_number() 
                           OVER ( 
                             ORDER BY articleid ) 
             FROM   articles) 
    SELECT * 
    FROM   ordereddata 
    WHERE  rn <= @UpperBound 
           AND rn >= @LowerBound 
    ORDER  BY articleid DESC 
END 

这是我给出@Upperbound和@LowerBound值时的结果

阿里克利德 54 55 56 57 . . .

Answer 1

试试这个

BEGIN
  SET NOCOUNT ON;
WITH OrderedData
as (
  select * , rn = ROW_NUMBER() OVER (ORDER BY articleid)  FROM articles 
  )
select * from OrderedData
where rn <= @UpperBound AND rn >= @LowerBound 
ORDER BY articleid desc
END

Answer 2

像这样尝试

BEGIN
SET NOCOUNT ON;
WITH OrderedData
as (
  select * , rn = ROW_NUMBER() OVER (ORDER BY articleid desc )  FROM articles
   )
select * from OrderedData
where rn <= @UpperBound AND rn >= @LowerBound 
ORDER BY articleid desc
END