Re: [GENERAL] Find min year and min value

[Richard Huxton]

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


--
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend