5 Replies Latest reply on Jan 31, 2013 1:18 PM by Christian Berg

    Query to find out last quarter data

    user13315956
      Hi All,

      I need a SQL query to find out. I have an amount field like below

      Period | Amt | Amt2
      ====================
      Jul | 0 | 0+20+30
      Aug | 20 | 0
      Sep | 30 | 0
      Oct | 0 | 0+50
      Nov | 50 |

      My need is Amt2 which needs to calculating in Qtr wise. Can any one post me a query for this.

      Thanks,
      Kamal