Oracle SQL Problem

From: heprox <srichards_at_wss-footwear.com>
Date: 18 Nov 2005 12:54:03 -0800
Message-ID: <1132347243.922108.60820@g14g2000cwa.googlegroups.com>

I have a table called GM_PRC with the following data:

SKU_NUM ITM_CD BEG_DT RET_PRC

-----------    --------    ---------    --------
000000898-01   000000898  2003-12-03    56.99
000000898-02   000000898  2003-12-03    56.99
000000898-03   000000898  2003-12-03    56.99
000000898-04   000000898  2003-12-03    56.99
000000898-05   000000898  2003-12-03    56.99
000000898-28   000000898  2003-12-29    56.99
000000898-30   000000898  2005-01-31    56.99
000000898-01   000000898  2005-05-11    58.99
000000898-02   000000898  2005-05-11    58.99
000000898-03   000000898  2005-05-11    58.99
000000898-04   000000898  2005-05-11    58.99
000000898-05   000000898  2005-05-11    58.99
000000898-28   000000898  2005-05-11    58.99
000000898-30   000000898  2005-05-11    58.99

...I want to select the most recent price for the ITM_CD (which is
comprised of all of the SKU_NUM's below it). I'm using the following:

select max(beg_dt) beg_dt,itm_cd,ret_prc from gm_prc where itm_cd = '000000898'
group by itm_cd,ret_prc order by beg_dt

...but I get:

BEG_DT ITM_CD RET_PRC

------------------- ------------ ------------

2005-01-31 00:00:00 000000898 56.99
2005-05-11 00:00:00 000000898 58.99

2 Row(s) affected

...what am I doing wrong? I should only get one line here for the
"2005-05-11" date? Received on Fri Nov 18 2005 - 14:54:03 CST