SQL Help
2004-11-30 08:10:55
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>
|
- SQL Help,
David E Ehresman <=
|
|
|