Re: SQL Break/total question

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