舉個例子給你參照 /* 數組#1 ID 1 3 5數組#2 ID -1 -3 -5*/SELECT * FROM #1 AS a, #2 AS b ORDER BY 1 /* ID ID 1 -1 1 -3 1 -5 3 -1 3 -3 3 -5 5 -1 5 -3 5 -5 */ SELECT * FROM #1 AS a,#2 AS b ,#2 AS c WHERE b.ID<c.ID ORDER BY 1 /* ID ID ID 1 -3 -1 1 -5 -1 1 -5 -3 3 -5 -3 3 -5 -1 3 -3 -1 5 -3 -1 5 -5 -1 5 -5 -3 */SELECT * FROM #1 AS a,#2 AS b ,#2 AS c,#2 AS d WHERE b.ID<c.ID AND c.ID<d.ID ORDER BY 1 /* ID ID ID ID 1 -5 -3 -1 3 -5 -3 -1 5 -5 -3 -1 */
取負數排前面,正數取2位和3位SELECT * FROM #2 AS a,#1 AS b ,#1 AS c WHERE b.ID<c.ID ORDER BY 1 /* ID ID ID -5 1 3 -5 1 5 -5 3 5 -3 1 5 -3 3 5 -3 1 3 -1 1 3 -1 1 5 -1 3 5 */SELECT * FROM #2 AS a,#1 AS b ,#1 AS c,#1 AS d WHERE b.ID<c.ID AND c.ID<d.ID ORDER BY 1 /* ID ID ID ID -5 1 3 5 -3 1 3 5 -1 1 3 5 */
算法实现以后返回一个新表n(id,zuhe);zuhe为元素的nvarchar;
/*
數組#1
ID
1
3
5數組#2
ID
-1
-3
-5*/SELECT *
FROM #1 AS a,
#2 AS b
ORDER BY 1
/*
ID ID
1 -1
1 -3
1 -5
3 -1
3 -3
3 -5
5 -1
5 -3
5 -5
*/
SELECT *
FROM #1 AS a,#2 AS b ,#2 AS c
WHERE b.ID<c.ID
ORDER BY 1
/*
ID ID ID
1 -3 -1
1 -5 -1
1 -5 -3
3 -5 -3
3 -5 -1
3 -3 -1
5 -3 -1
5 -5 -1
5 -5 -3
*/SELECT *
FROM #1 AS a,#2 AS b ,#2 AS c,#2 AS d
WHERE b.ID<c.ID AND c.ID<d.ID
ORDER BY 1
/*
ID ID ID ID
1 -5 -3 -1
3 -5 -3 -1
5 -5 -3 -1
*/
FROM #2 AS a,#1 AS b ,#1 AS c
WHERE b.ID<c.ID
ORDER BY 1
/*
ID ID ID
-5 1 3
-5 1 5
-5 3 5
-3 1 5
-3 3 5
-3 1 3
-1 1 3
-1 1 5
-1 3 5
*/SELECT *
FROM #2 AS a,#1 AS b ,#1 AS c,#1 AS d
WHERE b.ID<c.ID AND c.ID<d.ID
ORDER BY 1
/*
ID ID ID ID
-5 1 3 5
-3 1 3 5
-1 1 3 5
*/