title: Show records in SQL if count is more than 1
body: <p>I am creating a web app in which I need to print records which are appearing more than once.</p>
  
  <p>I created this table</p>
  
  <pre><code>create table nameandinfo
  (
      names nvarchar(40),
      contno nvarchar(40)
  )
  </code></pre>
  
  <p>and inserted 3 records:</p>
  
  <pre><code>select * from nameandinfo
  </code></pre>
  
  <p>This is the sample data:</p>
  
  <pre><code>Ibibo   998test389
  Nizam   959test681
  Ibrahim 998test389
  </code></pre>
  
  <p>Now I count the data by (contno)</p>
  
  <pre><code>SELECT [contno], COUNT(*) contact
  FROM nameandinfo
  GROUP BY [contno]
  </code></pre>
  
  <p>and I get the following results:</p>
  
  <pre><code>9594857681  1
  9987145389  2
  </code></pre>
  
  <p>I want to display only the rows for which the count is more than 1:</p>
  
  <pre><code>9987145389  2
  </code></pre>
  
  <p>What do I need to do?</p>