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
