将一系列数字拆分为等份SQL Sever

WITH NumberTable AS (
    SELECT Number, ROW_NUMBER() OVER (ORDER BY Number) AS RowNumber
    FROM YourTable
)
SELECT Number, NTILE(4) OVER (ORDER BY RowNumber) AS GroupNumber
FROM NumberTable;

WITH NumberTable AS (
    SELECT Number, ROW_NUMBER() OVER (ORDER BY Number) AS RowNumber
    FROM YourTable
),
GroupTable AS (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS GroupNumber
    FROM sys.columns
)
SELECT Number, GroupNumber
FROM NumberTable
CROSS JOIN GroupTable
WHERE GroupNumber <= CEILING((SELECT COUNT(*) FROM NumberTable) / 4.0)
ORDER BY Number, GroupNumber;