Oracle Help

[tenor_david]

I have a Table that tracks temperatures of a state on different days of different months. I would like to query this table and return the Average Temp for each month of the year. Any thoughts on how to do this?

Thanks

[Creosote]

select avg(temp_field) as AvgTemp, month(date_field) as MonthDate, year(date_field) as YearDate
group by month(date_field), year(date_field)

I dont use Oracle, but that should be fairly standard SQL.

[vass0922]

you forgot FROM

select avg(temp_field) as AvgTemp, month(date_field) as MonthDate, year(date_field) as YearDate
group by month(date_field), year(date_field)

SELECT avg(temp_field) as AvgTemp, 
       month(date_field) as MonthDate, 
       year(date_field) as YearDate
FROM [tablename]
GROUP BY month(date_field), year(date_field)

[Creosote]

I must have fallen asleep, or I just figured he would figure that out or something. LOL