title: mysql query, select rows distict and other rows is not distict
body: <p>I want to query the table with the result of name rows is distinct and the email rows are not distinct</p>
  
  <p>have this in my databasse looks like</p>
  
  <pre><code>Name    Email
  john    emai1@mywebsite.com
  john    emai1@mywebsite.com
  john    emai1@mywebsite.com
  pedro   emai12@mywebsite.com
  pedro   emai12@mywebsite.com
  pedro   emai12@mywebsite.com
  </code></pre>
  
  <p>and i want this query result </p>
  
  <pre><code>Name    Email
  john    emai1@mywebsite.com
          emai1@mywebsite.com
          emai1@mywebsite.com
  </code></pre>
  
  <hr>
  
  <pre><code>pedro   emai12@mywebsite.com
          emai12@mywebsite.com
          emai12@mywebsite.com
  </code></pre>
  
  <p>PLease i need your help. and thank you so much in advance.</p>