title: SQL query - WHERE (MAX) AND (= VALUE)
body: <p>I have a table with about 1000 rows. The rows contain <code>ID</code>, <code>IDUSER</code>, <code>DESCRIPTION</code> and <code>DATE</code>.<br>
  I need to get the <code>DESCRIPTION</code> with MAX <code>DATE</code> for a specific <code>IDUSER</code>. </p>
  
  <p>In the example, I need to get the "ASD" DESCRIPTION</p>
  
  <pre>
  ID     IDUSER        DESCRIPTION     DATE
  ----------------------------------------------
  1      1             ASD             4/16/2018   
  2      1             QWE             4/10/2018   
  3      2             ZXC             3/01/2018  
  4      2             BNM             1/26/2018  
  5      2             JKL             5/02/2018  
  6      3             IOP             3/14/2018  
  7      4             RTY             1/13/2018 
  </pre>
  
  <p>I'm trying something like</p>
  
  <pre><code>SELECT DESCRIPTION FROM TABLE WHERE IDUSER = 1 AND DATE = (SELECT MAX(DATE) FROM TABLE)
  </code></pre>
  
  <p>It's not working, maybe someone can help me with this?</p>