On 18-Feb-99 Robert Ouzen wrote:
> Hello
>
> Try to run a select command to get the occupancy  for each storage pool,
> but get an error. The syntax I ran:
>
> select logical_mb as "Capacity" from occupancy group by stgpool_name
>
> What is the correct syntax !!!!!

I think this is what you want:

select stgpool_name,sum(logical_mb) as "Capacity" from occupancy \
group by stgpool_name


-------------------------------------------
Alexander Verkooijen     SARA
Alexander Verkooijen     SARA
Systems Programmer       Academic Computing
alexander AT sara DOT nl        Services Amsterdam
-------------------------------------------
=========================================================================