selecting coordinates.

I have a simple query that I want to perform, but seem to be out of it this week and cannot come up with it.

Assume a table (simplified) as follows:

coordinates
(
x integer,
y integer
)

If this table is populated with values like

1,1
1,2
1,3
1,4
2,1
2,2
2,3
2,4
2,5

How can I use a single select statement to retrieve the following results:

	1,5
	2,5

that is, all unique x coordinates paired with the highest corresponding y coordinate?

thanks,

JE Received on Wed Jun 07 1995 - 00:00:00 CEST