title: Basic SQL Update statement on MAX
body: <p>I have a table 'dummy' like this</p>
  
  <pre><code>name, status , date, is-updated
  n1, s1, 2013-09-01, false
  n2, s2, 2013-09-01, false
  n1, s11, 2013-09-02, false
  </code></pre>
  
  <p>Now in-order to get the most recent timestamps for a particular name, i am using the query:</p>
  
  <pre><code>select name, status, max(date)
  from dummy
  where is-updated=false
  group by name,status
  </code></pre>
  
  <p>This is working fine as expected, returning two rows</p>
  
  <pre><code>n2, s2, 2013-09-01, false
  n1, s11, 2013-09-02, false
  </code></pre>
  
  <p>Now how to update the 'is-updated' value as 'true' for the above two rows ?? 'IN' clause in sql doesn't support multiple columns.</p>
  
  <pre><code>update dummy
  set is-updated = true
  where name, status, date in (
  
  select name, status, max(date)
  from dummy
  where is-updated=false
  group by name,status
  
  )
  </code></pre>
  
  <p>Can anyone help with this ? Thanks.</p>