Re: SQL Help
2004-11-30 08:18:37
Try this.
select date(pending_date), count(*) from volumes where -
status='PENDING' -
group by pending_date
________________________________
From: ADSM: Dist Stor Manager on behalf of David E Ehresman
Sent: Tue 11/30/2004 6:10 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL Help
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?
David
|
|
|