Board index » delphi » SQL sum, grouped by date intervals. How to?
Michael Sageryd
Delphi Developer |
Thu, 06 Aug 1998 03:00:00 GMT
SQL sum, grouped by date intervals. How to?
I want to sumarize the records in one table grouped in
"age-segments". The segment specs is in another table. I could pass the dates as parameters to the TQuery if its difficult to use two tables in the SQL. Table structures (Paradox): Sample records: TableB (date segments) Q: I want, for a given transType, have in this case three sums. one sum The above example tables should give the following for transType=1 : Is this possible with local SQL? A big PreThank's to anyone with a sugestion. |