title: Oracle : 'Count over Partition by' output on first row of the keyword alone
body: <p>I have to query a table which will look like as follows.</p>
  
  <pre><code>select count(*) over (PARTITION BY offer_status) as count, name, status
  from tablename
  </code></pre>
  
  <p><strong>Output will be as:<br></strong>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name1&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name1&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name2&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br>
  1&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;completed<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name1&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name2&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br></p>
  
  <p><br></p>
  
  <p><strong>I would like to get it as :<br></strong>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name1&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  &nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  3&nbsp;&nbsp;|&nbsp;&nbsp;name2&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br>
  1&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;completed<br>
  &nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br>
  &nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;entered<br>
  &nbsp;&nbsp;&nbsp;&nbsp;|&nbsp;&nbsp;name3&nbsp;&nbsp;|&nbsp;&nbsp;cleared<br></p>
  
  <p><br>
  To get the count of status only for the first occurance of the keyword (of status), as it is not necessary to get the count again and again.</p>
  
  <p><br>
  Or you can suggest me any other way to get it done.</p>