ADSM-L

SQL Help

2004-11-30 08:10:55
Subject: SQL Help
From: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 30 Nov 2004 08:10:34 -0500
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

<Prev in Thread] Current Thread [Next in Thread>