How I can accomplish in Local SQL such a simple task as
e.g. calculating totals of year sales:

SELECT EXTRACT(YEAR FROM T.DDATE) as Y, SUM(T.NTOTAL)
FROM TTable T
GROUP BY Y

Syntax is correct, but in result set there is no grouping at all.
Or is there another way to accomplish this?

Regards, KK
--

   K.Kuzenko Galilei Soft.(Kiev,Ukraine).