>> 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