title: SELECT DISTINCT for only one Column in Google Sheets Query
body: <p>Let's say I have the following query.</p>
  
  <pre><code>=query (A:C; "SELECT A, B, C")
  </code></pre>
  
  <p>How can I modify it so that it returns no duplicate A?</p>
  
  <p>In other words, when several rows contain the same A, I want the results to include only one of those rows (the last one). Duplicates in other columns should be allowed.</p>
  
  <p>Here I have found an answer for SQL Server, but I can't figure out how to do this in Google Sheets Query
  <a href="https://stackoverflow.com/questions/5021693/distinct-for-only-one-column">DISTINCT for only one Column</a></p>
  
  <p>what I have:</p>
  
  <pre><code>A,             B,        C
  lucas@abc.com, approved, 05/04/2019
  lucas@abc.com, not set, 05/05/2019
  lucas@abc.com, refunded, 05/06/2019
  john@xyz.com, approved, 05/06/2019
  john@xyz.com, approved, 05/07/2019
  john@xyz.com, approved, 05/07/2019
  </code></pre>
  
  <p>what I want:</p>
  
  <pre><code>A,             B,        C
  lucas@abc.com, refunded, 05/06/2019
  john@xyz.com, approved, 05/07/2019
  </code></pre>