Find min year and min value

[Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx>]

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly