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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
