title: SQL get distinct first name and last name
body: <p>I have this query here <code>select distinct id, FirstName, LastName
                                          from table</code></p>
  
  <p>This returns me a list of people, first some of the ids were returning duplicates, but I used <code>distinct</code> to fix that, but I still have an issue and that some of the people are duplicates.</p>
  
  <p>Is there also away to put a distinct on the first and last name as well as id? (Some results do not come with an id)</p>
  
  <p>Results (without distinct id):</p>
  
  <pre><code>id - 01 - firstname - james - lastname - smith
  id - 01 - firstname - james - lastname - smith
  id - 02 - firstname - john - lastname - hicks
  id - 02 - firstname - john - lastname - hicks
  id -    - firstname - tom - lastname - nicks
  id -    - firstname - tom - lastname - nicks
  </code></pre>
  
  <p>Expecting:</p>
  
  <pre><code>id - 01 - firstname - james - lastname - smith
  id - 02 - firstname - john - lastname - hicks
  id -    - firstname - tom - lastname - nicks
  </code></pre>