Re: ORA-00979

From: Tim Slattery <Slattery_T_at_bls.gov>
Date: Thu, 25 Oct 2012 12:54:52 -0400
Message-ID: <diri889p1i9tafut05ltibcc21uhf24p66_at_4ax.com>

Geoff Muldoon <geoff.muldoon_at_trap.gmail.com> wrote:

>If you only want the row for MAX(index_date) then you should SELECT
>that, not use it in a HAVING clause. Then you will need to GROUP BY
>every other column that has not had an aggregation/function applied to
>it.

Thanks, looks like that's it.

I'm converting an application from Sybase to Oracle. The SQL statement I posted ran perfectly fine in Sybase. Different SQL dialects, I suppose.

-- 
Tim Slattery
Slattery_T_at_bls.gov

Received on Thu Oct 25 2012 - 18:54:52 CEST