Re: easy query (?)

From: Karl M. Nordquist <karln_at_brightwood.com>
Date: 1997/03/11
Message-ID: <3326100B.73C3@brightwood.com>#1/1

Alice Erickson wrote:
> ...
> select city, max(temp), time from table
> group by city

Try
select distinct city, max(temp, time from table group by city;

This should get you what you need.

HTH Regards

//Karl

-- 
====================================================
Karl M. Nordquist		karln_at_brightwood.com
Application Development
Bright Wood Corporation
Madras, Oregon
====================================================

Received on Tue Mar 11 1997 - 00:00:00 CST