RE: SQL Break/total question

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
--