Re: Find min year and min value

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