title: Sql select last record with specific WHERE
body: <p>I have table <code>login</code>:</p>
  
  <pre><code>ID - DATE - USER_ID
  1 - 13.4.2016 20:00 - 1
  2 - 13.4.2016 20:10 - 1
  3 - 13.4.2016 20:20 - 1
  4 - 13.4.2016 20:30 - 1
  5 - 13.4.2016 21:00 - 2
  </code></pre>
  
  <p>How to select last row of <code>user_id</code> (last user login  <code>:-)</code> )?</p>
  
  <p><strong>Output:</strong> <code>4 - 13.4.2016 20:30 - 1</code></p>
  
  <p>My try not working:</p>
  
  <pre><code>SELECT * FROM login ORDER BY ID DESC WHERE USER_ID = 1
  </code></pre>
  
  <p>But I get sql syntax error, I don't know why, can you help me please?</p>
  
  <p>Thank you for your replye.</p>