Re: Use of MAX function - right or wrong?

"Kay Cee" <cee.1_at_osu.edu> wrote in message news:bei0q6$hs5$1_at_charm.magnus.acs.ohio-state.edu...
> I'm trying to create an SQL query using a table with two fields. There
are
> multiple date rows in column B associated with each row in column A. I
was
> looking at using the MAX function to retrieve the most current date value
> for each data row in column A, but the MAX function only retrieves a
single
> data row with the most recent date, irrespective of the values in column
A.
> Is there a way around this?

look at how the GROUP BY clause works, it should help you out.

BTW didn't you used to have a sunshine band?

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************