title: sql update query
body: <p>I need an update query to set the null values with another value in the same group</p>
  
  <p>for example</p>
  
  <pre><code> Table
      filed1   filed2      filed3
      1          e         1/1/2009
      1          e         null
      1          e         1/1/2009
      2          f         2/2/2009
      2          f         2/2/2009
      2          f         null
      3          g         3/3/2009
      3          g         null
  </code></pre>
  
  <p>Expected Result</p>
  
  <pre><code>filed1   filed2      filed3
  1          e         1/1/2009
  1          e         1/1/2009
  1          e         1/1/2009
  2          f         2/2/2009
  2          f         2/2/2009
  2          f         2/2/2009
  3          g         3/3/2009
  3          g         3/3/2009
  </code></pre>