title: How can I use rank function without actually showing rank?
body: <p>I am getting:</p>
  
  <pre><code> YEAR   MONTH        DAY SHARES_TRADED NUM_TRADES DOLLAR_VOLUME
  ---------- ---------- ---------- ------------- ---------- -------------
        rank
  ----------
        2010      1          4    1425504460    4628115    3.8495E+10
       1
  
        2010      1          5    1754011750    5394016    4.3932E+10
       2
  
        2010      1          6    1655507953    5494460    4.3817E+10
       3
  </code></pre>
  
  <p>But I want to get:</p>
  
  <pre><code>YEAR   MONTH        DAY SHARES_TRADED NUM_TRADES DOLLAR_VOLUME
  ---------- ---------- ---------- ------------- ---------- -------------
  
  
        2010      1          4    1425504460    4628115    3.8495E+10
  
  
        2010      1          5    1754011750    5394016    4.3932E+10
  
  
        2010      1          6    1655507953    5494460    4.3817E+10
  </code></pre>
  
  <p>I am using rank function like :</p>
  
  <pre><code>select year, month, day, shares_traded,num_trades, dollar_volume, rank() over (partition by year, month order by day asc) "rank" from nyse;
  </code></pre>
  
  <p>I want to use rank function but I don't want rank to appear.Is there a way?</p>