Find min year and min value - Mailing list pgsql-general

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
            MIN(value) AS minv
    FROM
            public_one_table.data
    WHERE
            year =
            (
                SELECT
                        MIN(year) AS min_year
                FROM
                        public_one_table.data
                WHERE
                        id_variable = 1
            ) AND
            id_variable = 1



Thanks for any help!

Stef