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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
