how to Distinct two colums but select other colums

ALPEN07 · April 4th, 2008, 04:08 AM

Hi all,

I have a table,

Station------Lat------Lon

Sta1_________10.1_____10.2
Sta__________10.1_____10.2
Sta2_________15.5_____15.5

I am trying to distinct the table with Lat and Lon values. And select ONE OF the Station values.

So final query result must be;

Station------Lat------Lon

Sta1_________10.1_____10.2
Sta2_________15.5_____15.5

Could you please help me?

Preethi · April 4th, 2008, 07:53 AM

Try this:
SELECT MIN(Station) Station, Lat, Lon
FROM <Table name>
GROUP BY Lat, Lon

G.R.Preethiviraj Kulasingham

ALPEN07 · April 5th, 2008, 06:08 AM

Thanks a lot.