Re: SQL Break/total question

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Frank

That would be  GROUP BY to get aggregates. See if this gives you what 
you want -

SELECT LGSESN, COUNT(*) AS SESNCNT FROM anloga
WHERE LGSESN NOT LIKE '%ARCHIVE%'
GROUP BY LGSESN
order by LGSESN

By the way, this could perform rather poorly - I think it requires a 
full table scan, due to the NOT LIKE, for sure, and , even more, 
wildcards on both ends of the comparison value. Unfortunately, I'm not 
sure there is an alternative.

HTH
Vern

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