case statement
bnjutkJun 16 2009 — edited Nov 6 2010hi
I have data like this in the table
date value
1-MAY-09 20
2-MAY-09 30
3-MAY-09 40
4-MAY-09 50
5-MAY-09 60
1-JUN-09 70
2-JUN-09 80
3-JUN-09 90
4-JUN-09 10
5-JUN-09 60
i want to have like this with a query
date value value_last_month
1-MAY-09 20
2-MAY-09 30
3-MAY-09 40
4-MAY-09 50
5-MAY-09 60
1-JUN-09 70 20
2-JUN-09 80 30
3-JUN-09 90 40
4-JUN-09 10 50
5-JUN-09 60 60
i mean in third column i want to get the value of same date lastmonth
can any one help me out?
thanks
balaji
Edited by: chinnu on Jun 16, 2009 2:51 AM