关于在sql中对记录进行排序 [英] Regarding sorting the Records in sql

问题描述

如何通过排除特定行来对表中的记录(按字母顺序)进行排序，并且默认情况下必须首先显示被排除的行.

例如

让我的桌子如下

编号名称
1 A
2 B
3 c
4 x

我需要按以下顺序对记录进行排序

名称
X
A
B
C

How can i sort the record (alphabetically) in table by excluding specific row and that excluded row has to be displayed first by default.

for example

Let my table be as follow

Id Name
1 A
2 B
3 c
4 x

i need the record to be sorted as follow

Name
X
A
B
C

推荐答案

从表中选择名称WHERE Name = X
UNION
从表中选择名称WHERE Name<> X ORDER BY名称

实际上，您有两个表，一个接一个

SELECT Name FROM Table WHERE Name=X
UNION
SELECT NAME FROM Table WHERE Name <> X ORDER BY Name

Actually, you have two tables one after another

这里是一个示例方法

Here is a sample approach

CREATE TABLE #SampleTable
(
    ID INT,
    [Name] VARCHAR(50)
)

INSERT INTO #SampleTable
SELECT 1, 'A' UNION ALL
SELECT 2, 'B' UNION ALL
SELECT 3, 'C' UNION ALL
SELECT 4, 'X'

SELECT [Name] FROM
(
    SELECT CASE WHEN ID = 4 THEN 0 ELSE 1 END AS SortOrder, ID, [Name] FROM #SampleTable
) T
ORDER BY SortOrder, [Name]

DROP TABLE #SampleTable

这篇关于关于在sql中对记录进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！