[SQL] SQL problem

[Salvador Mainé]

Hello:

I have a table with pluviometrical data

meteo (rain float, day date)

I want to select the the day of maximum value for each year.It should be
something like :


select max(rain),day from meteo group by date_part('year', day);


but it obiously doesn't work.
I thought of doing it with aggregates, but it's far too complicated. Is
there an 'easy' way to do this?


 

-- 
Salva

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster