I don't think Oracle allows that. I've often wanted to do that myself, so I sympathize.
---- Steve Sapovits GSI Commerce [EMAIL PROTECTED] > -----Original Message----- > From: Fong, Anna [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 14, 2002 3:01 PM > To: [EMAIL PROTECTED] > Subject: OT: Oracle Group By statement > > Can anyone point me to the answer? > > I want to use an arbitrary group in the group by statement. I can group > by year but want to change the calendar year to another unit of measure > such as quarter. > > This works: > > select to_char(actual_date,'YYYY'), sum(value) from daily_data > where sensor_id=? > group by to_char(actual_date,'YYYY') > > Any ideas? > > > -------------------------------------------------------- > > Anna Q. Fong, Webmaster > California Data Exchange Center
