title: Fetch all duplicate rows
body: <p>I want to fetch only duplicate rows with  repetition of values in <strong>name</strong> column occurring multiple times without the count column and I don't want to group them. Examples given below.
  e.g.</p>
  <p>for example this is table:-</p>
  <pre><code>    id |  name  | project 
  ----+--------+---------
    1 | aditya | java
    2 | aditya | cloud
    3 | bradly | go
    4 | cooper | java
    5 | alexa  | elixir 
    6 | jason  | search
    7 | jason  | java
  </code></pre>
  <p>result should be :-</p>
  <pre><code>   id |  name  | project 
  ----+--------+---------
    1 | aditya | java
    2 | aditya | cloud
    6 | jason  | search
    7 | jason  | java
  </code></pre>