2011/09/27 05:32 -0700, supr_star
Here's a simple query: select name,status,min(dt), max(dt),count(*) from
mytable group by name I need an efficient way to get this data, along with the
status of the row with the max(dt). 'status' is not in the group by, so I get
apparently random sta
nuary 12, 2004 2:48 AM
Subject: Re: query efficiency
> Thats not really what I meant. I have 5 (or whatever) columns in a
table.
> I need to update values changed in those columns during processing.
But I
> have no way of knowing what column values need updating. Is it worth
my
> w
