Stefan Schwarzer wrote:
>>> 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
SELECT year, value FROM ...
--
Richard Huxton
Archonet Ltd