help with query with a date 1

[cheryl27284]

I have a query where I want to return records with the month instead of the date. The records are listed by day. Here is the Query:

Select MONTH(row_date) as Mnth,sum(acwtime)/sum(acdcalls) as acw from dagent group by ???

I need to group by the month so I do not get every record but I keep getting a syntax error. If I group by row_date it gives me every day. This works in SQL Server but not in Informix. Can anyone help?

 

[PHV]

And this ?
Select MONTH(row_date) as Mnth,sum(acwtime)/sum(acdcalls) as acw from dagent group by 1
Or this ?
Select MONTH(row_date) as Mnth,sum(acwtime)/sum(acdcalls) as acw from dagent group by MONTH(row_date)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cheryl27284]

That worked!! Why group by 1? I know I could not group by month(row_date) but I tried the group by 1 and it worked?? What does that mean to group by 1?

 

[PHV]

Group by the 1st column.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886