M
Marty
Hello,
TIA for your expertise and knowledge. I'm trying to do a
query that will output the max value of Amt for each group
of Lat/Lon pairs. The example below shows why I can not
consider only Lat or only Lon in the group by function; it
has to be both and that's where I run into trouble. My
result return every record in the table. Any help would
be greatly appreciated.
date Seq Amt Lat Lon
20030911 130 69 30 18.03 -66.572
20030911 132 67 33 18.03 -66.572
20030911 139 64 54 18.07 -66.572
20030911 132 63 33 18.07 -66.572
20030911 139 64 54 18.07 -66.573
20030911 132 63 33 18.07 -66.573
Desired Result:
date Seq Amt Lat Lon
20030911 132 67 33 18.03 -66.572
20030911 132 63 33 18.07 -66.572
20030911 132 63 33 18.07 -66.573
TIA for your expertise and knowledge. I'm trying to do a
query that will output the max value of Amt for each group
of Lat/Lon pairs. The example below shows why I can not
consider only Lat or only Lon in the group by function; it
has to be both and that's where I run into trouble. My
result return every record in the table. Any help would
be greatly appreciated.
date Seq Amt Lat Lon
20030911 130 69 30 18.03 -66.572
20030911 132 67 33 18.03 -66.572
20030911 139 64 54 18.07 -66.572
20030911 132 63 33 18.07 -66.572
20030911 139 64 54 18.07 -66.573
20030911 132 63 33 18.07 -66.573
Desired Result:
date Seq Amt Lat Lon
20030911 132 67 33 18.03 -66.572
20030911 132 63 33 18.07 -66.572
20030911 132 63 33 18.07 -66.573