如何检查表中列的数字分布

Question

我有此表：

CREATE TABLE [dbo].[Phrase] (
    [PhraseId]              UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [English]               NVARCHAR (250)   NOT NULL,
    [EnglishAscii]          AS               (ascii([English])) PERSISTED,
    [EnglishHash]           AS               (CONVERT([bigint],hashbytes('md5',[English])%(5)+(5))) PERSISTED,
    PRIMARY KEY CLUSTERED ([PhraseId] ASC)
);

我想做的是检查EnglishHash列的分布。

有没有办法进行选择，可以向我展示为EnglishHash的每个值分配了多少行？

Answer 1

SELECT EnglishHash, COUNT(*) as [Count] FROM Phrase GROUP BY EnglishHash