<div>
I wonder whether the query optimizer will eliminate redundant calls of the function?
</div>


<div>
Sure it will, as long as they are written identically.
</div>


<div>
<div class="content wysiwyg-content">
In Sybase adaptive server 11, the following gave me 'invalid column name mnth'. How can I summarize sales by month?<br />
<br />
select sum( subtotal ) as sales_summary,<br />
&nbsp; datediff ( mm, &nbsp;'Jan 1 2000', order_date ) as mnth<br />
from sales_order<br />
where mnth &gt;&nbsp;0<br />
group by mnth<br />

</div>
</div>


In Sybase adaptive server 11, the following gave me 'invalid column name mnth'. How can I summarize sales by month?

select sum( subtotal ) as sales_summary,
  datediff ( mm,  'Jan 1 2000', order_date ) as mnth
from sales_order
where mnth > 0
group by mnth


I wonder whether the query optimizer will eliminate redundant calls of the function?

Sure it will, as long as they are written identically.

group by a computed column didn&amp;#39;t work in sybase. why?

In Sybase adaptive server 11, the following gave me &amp;#39;invalid column name mnth&amp;#39;. How can I summarize sales by month?

select sum( subtotal ) as sales_summary,
  datediff ( mm,  &amp;#39;Jan 1 2000&amp;#39;, order_date ) as mnth
from sales_order
where mnth &amp;gt; 0
group by mnth


group by a computed column didn't work in sybase. why?

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.