On Wed, 5 Oct 2011, Chris Curvey wrote:
> Based on your subject line, I'm guessing that you want something like this:
>
> select quant, param, site_id, sample_date, str_name from chemistry where
> param = 'TDS' and str_name = 'BurrowCrk' and quant = (select max(quant)
> from chemistry where param = 'TDS' and str_name = 'BurrowCrk')
Chris,
Thank you. I missed seeing the latter part.
This returns 0 rows, but it puts me on the right track.
Rich