如何在SQL Server查询中返回的一组多行中获得n个最常用的单词？

-- 创建临时表
CREATE TABLE #TempTable (
    Word VARCHAR(100),
    Frequency INT
)

-- 计算单词出现次数并插入临时表
INSERT INTO #TempTable (Word, Frequency)
SELECT SUBSTRING(TextColumn, Number, CHARINDEX(' ', TextColumn + ' ', Number) - Number) AS Word,
       COUNT(*) AS Frequency
FROM TextTable
JOIN (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS Number
    FROM master..spt_values
) Numbers ON Number <= LEN(TextColumn) - LEN(REPLACE(TextColumn, ' ', '')) + 1
GROUP BY SUBSTRING(TextColumn, Number, CHARINDEX(' ', TextColumn + ' ', Number) - Number)

-- 返回前n个出现次数最多的单词
SELECT TOP (n) Word, Frequency
FROM #TempTable
ORDER BY Frequency DESC

-- 删除临时表
DROP TABLE #TempTable