selecting coordinates.
From: JE <eckley_at_capsrv.jhuapl.edu>
Date: 1995/06/07
Message-ID: <eckley-070695085432_at_lurch.jhuapl.edu>#1/1
Date: 1995/06/07
Message-ID: <eckley-070695085432_at_lurch.jhuapl.edu>#1/1
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