How can I list duplicate values out of a table?

Viewed 2358

I have this table. Some of the rows have duplicate values in the Kanji column.

How can I show these rows where the same Kanji appears more than once?

CREATE TABLE [dbo].[Phrase] (
    [PhraseId]              UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [English]               NVARCHAR (250)   NOT NULL,
    [Kanji]                 NVARCHAR (250)   NULL,
    PRIMARY KEY CLUSTERED ([PhraseId] ASC) );
6 Answers
Related