求sql语句

Id parentId
17 16
16 0
15 0
14 1
13 6
12 8
11 1
10 2
9 1
8 0
7 0
6 0
5 1
4 2
3 1
2 0
1 0
parentId为父节点，不为0的是子节点
最终想输出ID的顺序为16,17,15,8,12,7,6,13,2,4,10,1,3,5,9,11,14
其实
就是一个父节点（降序），然后下面是子节点（升序）
然后再父节点（降序），然后下面是子节点（升序）

---

顶一下，先占个地。

---

引用

....

SQL code:
DECLARE @TB TABLE([Id] INT, [parentId] INT)
INSERT @TB
SELECT 17, 16 UNION ALL
SELECT 16, 0 UNION ALL
SELECT 15, 0 UNION ALL
SELECT 14, 1 UNION ALL
SELECT 13, 6 UNION ALL
SELECT 12, 8 UNION ALL
SELECT 11, 1 UNION ALL
SELECT 10, 2 UNION ALL
SELECT 9, 1 UNION ALL
SELECT 8, 0 UNION ALL
SELECT 7, 0 UNION ALL
SELECT 6, 0 UNION ALL
SELECT 5, 1 UNION ALL
SELECT 4, 2 UNION ALL
SELECT 3, 1 UNION ALL
SELECT 2, 0 UNION ALL
SELECT 1, 0

DECLARE @STR VARCHAR(MAX)
SET @STR=''

;WITH CTE AS
(
SELECT *,ID AS GRP from @TB WHERE [parentId]=0
UNION ALL
SELECT T.*,CTE.ID from @TB AS T JOIN CTE ON T.[parentId]=CTE.ID
)
SELECT @STR=@STR+','+RTRIM(ID)
from CTE
ORDER BY GRP DESC,[parentId],ID

SELECT STUFF(@STR,1,1,'')
/*
16,17,15,8,12,7,6,13,2,4,10,1,3,5,9,11,14
*/

---

楼上高手高手高高手，谢谢

---

SQL code

---

Co