Re: Call a function in the group by expression

Try this:
SELECT MONTH(ETIME),ENAME
from ELOG
GROUP BY MONTH(ETIME),ENAME; Hope this helps.
<tjmxyz_at_my-deja.com> wrote in message news:8lpfdt$hf9$1_at_nnrp1.deja.com...
> Is there someway to call a function in the group by expression
>
> I.E.
>
> SELECT ETIME,ENAME from ELOG GROUP BY MONTH(ETIME),ENAME;
>
> I get the error: ETIME is not a group by expression....
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 27 2000 - 00:00:00 CDT