Hello everyone, I would like to get the sum of column A, where my search value is between column B and column C.
I tried it with this query, but does not seem to work properly:
SELECT SUM (T.columnA) FROM T WHERE ? BETWEEN T.columnB AND T.columnC
T.columnA, T.columnB and T.columnC are INT
ie. ? = Year (Get (currentDate))