If you are on V7 (or I think V6), there is a rollup feature. With the
addition below you should get sub-totals and LGDATE, and a grand total.
This might be what you want. Or not.
SELECT LGSESN, LGDATE FROM anloga
WHERE LGSESN NOT LIKE '%ARCHIVE%'
group by LGSESN, LGDATE
with rollup -- <<<<<<<<< Add this
order by LGSESN, LGDATE
Sam
On 2/22/2013 11:20 AM, fbocch2595@xxxxxxx wrote:
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
