Re: SUM and GROUP BY...

From: TurkBear <noone_at_nowhere.com>
Date: Mon, 02 Apr 2001 10:15:25 -0500
Message-ID: <9n5hct0kd0nbe5e19i1imk90a1vc0l0njv@4ax.com>

Yep...I did have it wrong...

Sorry...
( I had it correct when I tested it with an analogous select from my data :

---

  1 select office_nm,sum(cmptn_rt) from hr_cur_rptng  2 where months_between(sysdate,AGENCY_SRVC_BEG_DT) < 24  3 and rownum < 120
 4* group by office_nm

---

Ole Christian <olecl_at_stud.idb.hist.no> wrote:

>Thank you very much.
  Received on Mon Apr 02 2001 - 10:15:25 CDT