title: Convert excel formula to Oracle SQL
body: <p>How to convert excel formula to oracle sql.
  <strong>=A2&amp;COUNTIF($A$2:A2,A2)</strong></p>
  <p>In excel in have 2 columns: order and helper, i am running the above formula in excel column 2, which basically copy data from order column and add suffix to same order_id.</p>
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;table&gt;
    &lt;thead&gt;
      &lt;tr&gt;
        &lt;th&gt;Order_id&lt;/th&gt;
        &lt;th&gt;Helper&lt;/th&gt;
      &lt;/tr&gt;
    &lt;/thead&gt;
    &lt;tbody&gt;
      &lt;tr&gt;
        &lt;td&gt;45235&lt;/td&gt;
        &lt;td&gt;452351&lt;/td&gt;
      &lt;/tr&gt;
      &lt;tr&gt;
        &lt;td&gt;45235&lt;/td&gt;
        &lt;td&gt;452352&lt;/td&gt;
      &lt;/tr&gt;
    &lt;/tbody&gt;
  &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>
  <p><a href="https://i.stack.imgur.com/G3Q2z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/G3Q2z.png" alt="enter image description here" /></a></p>