Re: SQL Help
2004-12-01 10:18:40
That does not give me the desired results:
tsm: ULTSM> select date(pending_date) as "Date",count(*) from volumes
where -
cont> status='PENDING' group by pending_date
Date Unnamed[2]
---------- -----------
2004-11-27 1
2004-11-27 1
2004-11-27 1
2004-11-27 1
2004-11-27 1
group by pending_date groups by the time stamp not the date stamp. I
want a count of pending tapes by date not by second.
>>> gretchen AT PRINCETON DOT EDU 12/1/2004 10:02:40 AM >>>
The group by statement is incorrect, use the following:
group by pending_date
the conversion to date format is already taken care of
in the first part of the select statement.
David E Ehresman wrote:
> tsm: ULTSM> select date(pending_date) as "Date",count(*) from
volumes
> where -
> cont> status='PENDING' group by "Date"
> ANR2940E The reference 'Date' is an unknown SQL column name.
>
> |
>
> .........................................................V.....
> e",count(*) from volumes where status='PENDING' group by
> "Date"
>
> ANS8001I Return code 3.
>
>
>
>>>>mark.stapleton AT BERBEE DOT COM 11/30/2004 9:09:03 AM >>>
>
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] 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 (stapleton AT berbee DOT com)
> Berbee Information Networks
> Office 262.521.5627
|
|
|