This discussion is archived
5 Replies Latest reply: Jan 31, 2013 5:18 AM by Christian Berg RSS

Query to find out last quarter data

user13315956 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points