RE: SQL Break/total question

["Richard Casey" <casey_r@xxxxxxxxxxxxxxxx>]

Try this:

  SELECT   LGSESN,COUNT(*)
  FROM     anloga
  WHERE    LGSESN NOT LIKE '%ARCHIVE%'
  GROUP BY LGSESN
  ORDER BY LGSESN


I found a SQL tutorial at http://www.w3schools.com/sql/default.asp

You could also look at the IBM SQL Reference manual at
http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/index.jsp?topic=/db2
/rbafzintro.htm

Have fun!
Richard

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of fbocch2595@xxxxxxx
Sent: Friday, February 22, 2013 10:56 AM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Break/total question


Hi Folks, this statement runs fine;

SELECT LGSESN, LGDATE FROM anloga
WHERE LGSESN NOT LIKE '%ARCHIVE%'
order by LGSESN                  


but if I want to only have each LGSESN output a single line with the total
number of hits for all the LGSESN's, what's the syntax for that?   


Is there any tip sheets or manuals for learning SQL? 

Thanks, Frank
--