Re: Find min year and min value - Mailing list pgsql-general

>> Hi there,
>> I am trying to find in a table with different variables, countries
>> and years the
>>     lowest year
>> and within that year the
>>     lowest value
>> The following SELECT works, but I wonder if it is "elegant". Can
>> you recommend any other solution?
>
> SELECT value AS minv FROM public_on_table.data
> WHERE id_variable = 1
> ORDER BY year, value LIMIT 1

But that brings only the min value, not the min year. I need to know
both of them, something like

      (min year = ) 1972, (min value = ) 20

Stef