title: First Negative Value Row in Oracle
body: <p>How do I pick the first negative value row using CASE Statement? I do not want to use Where condition since it applies the condition to the entire data.
  In the below sample, I just want to make the maximum of negative values (-469) to ABS(-469) which is 469 and leave the rest as is.</p>
  <p>My <code>MAX(CASE WHEN -469)...</code>does not seem to work. Assume there is an ordering field.</p>
  <pre><code>Sample 
  ------
  1281
  -469
  -469
  -509
  -1359
  -1359
  -2759
  -2829
  </code></pre>