title: How can I list duplicate values out of a table?
body: <p>I have this table. Some of the rows have duplicate values in the Kanji column. </p>
  
  <p>How can I show these rows where the same Kanji appears more than once?</p>
  
  <pre><code>CREATE TABLE [dbo].[Phrase] (
      [PhraseId]              UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
      [English]               NVARCHAR (250)   NOT NULL,
      [Kanji]                 NVARCHAR (250)   NULL,
      PRIMARY KEY CLUSTERED ([PhraseId] ASC) );
  </code></pre>