title: Is it possible to use MAX in update statement using sql?
body: <p>i am trying to use the MAX function in sql statement.  Here is what i am trying to do:
  something like this:</p>
  
  <pre><code>UPDATE MainTable
          SET [Date] = GETDATE()
  
          where [ID] = Max
  </code></pre>
  
  <p>I know this is wrong specially where i put the where condition but cannot figure out how to use max and update in the same statement.  thanks</p>