Hi Vern, your command gave me what I want...how can I add the LGDATE field to this and still get the break and total?
SELECT LGSESN, COUNT(*) AS SESNCNT FROM anloga
HERE LGSESN NOT LIKE '%ARCHIVE%'
ROUP BY LGSESN
rder by LGSESN
-----Original Message-----
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Fri, Feb 22, 2013 11:13 am
Subject: Re: SQL Break/total question
Hi Frank
That would be GROUP BY to get aggregates. See if this gives you what
ou want -
SELECT LGSESN, COUNT(*) AS SESNCNT FROM anloga
HERE LGSESN NOT LIKE '%ARCHIVE%'
ROUP BY LGSESN
rder by LGSESN
By the way, this could perform rather poorly - I think it requires a
ull table scan, due to the NOT LIKE, for sure, and , even more,
ildcards on both ends of the comparison value. Unfortunately, I'm not
ure there is an alternative.
HTH
ern
On 2/22/2013 9:55 AM, fbocch2595@xxxxxxx wrote:
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
umber 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
