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
|