SQL 服务器 : how to order by using a starting value

Question

查询以从特定值开始的值对表进行排序。

电流:

ZQE123
ABC123
ABC324
ALP234

如果我从变量'ABC324'订购

ABC324
ALP234
ZQE123
ABC123

如果我从变量 'ZZZ123' 订购

ABC123
ABC324
ALP234
ZQE123

它基本上是一个有序的循环列表，具体取决于指定的变量。

我试过使用 RANK() 函数，但运气不太好。

SELECT 
    Location, 
    RANK() OVER (ORDER BY Location) 
FROM Table1

输出:

ZQE123    4 
ABC123    1
ABC324    2 
ALP234    3

如何让它根据当前位置执行此操作？

Answer 1

ORDER  BY CASE
            WHEN YourCol >= @Variable THEN 0
            ELSE 1
          END,
          YourCol 

将是一种方式。或另一个(假设没有空值)

WITH CTE
     AS (SELECT 1 AS Part,
                *
         FROM   T
         WHERE  YourCol >= @Variable
         UNION ALL
         SELECT 2 AS Part,
                *
         FROM   T
         WHERE  YourCol < @Variable)
SELECT *
FROM   CTE
ORDER  BY Part,
          YourCol