From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David E Ehresman >I'm trying to get a count of tapes pending by date. I'm using: > select date(pending_date),count(*) from volumes where >status='PENDING' - > group by date(pending_date) >but I get the error message: > ANR2904E Unexpected SQL key word token - 'DATE'. >pointing to the date in the group by clause. > >Anyone know how to get a pending count by date?
Try select date(pending_date) as "Date",count(*) from volumes where status='PENDING' group by "Date" -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
