SQL Server窗口函数子句中的条件排序顺序

您可以在两个方向分配行号，然后在外部选择一个

order by

select  *from    (        select  row_number() over (order by SortColumn) rn1        ,       row_number() over (order by SortColumn) rn2        ,       *        from    @t        ) as SubQueryAliasorder by        case when @asc=1 then rn1 end,       case when @asc=0 then rn2 end desc