Add a "group by node_name" phrase - I guess...

Tom Haddad wrote:
>
> Im running Adsm v3.1 on AIX 4.3   I want to produce this report with
> SELECT.....
>
> List the node names, their last_bytes_recvd and total the last_bytes_recvd.  I
> get the info from the NODES table in the database.
>
> When I code statement 1, i get the total. When I insert node_name and
> lastsess_recvd fields  it fails with a syntax error (statement 2).
>
> 1     SELECT SUM(LASTSESS_RECVD) AS "Total Bytes" FROM NODES
> 2     SELECT SUM(LASTSESS_RECVD) AS "Total Bytes", NODE_NAME, LASTSESS_RECVD
> FROM NODES

--
Mr. Lindsay Morris
Mr. Lindsay Morris
Certified: AIX,ADSM, TSM, HACMP,SP
Gresham Enterprise Storage
lmorris AT openmic DOT com
606-253-8000