Snow Brothers Sunny Leone Ni Esara..

[spidereddy]

 

avna..inni rojulu sunny gurinchi thappu ga ankunna...ee sari kanipiste personal ga apology cheppukovalani vundi

apooklogy chepthava..

[Nellore Pedda reddy]

Ee subject teleenodu open chesina enti upayogam

[spidereddy]

select sum(
case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char (sysdate,'YYYYMM')
then decode(sal_1,0,NULL, salary/sal_1) end)
end as annual_sal
from employee
group by emp_key,sal_1;

 

 

this is the right one..if anyone is interested..

[babugaru]

select sum(
case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char (sysdate,'YYYYMM')
then decode(sal_1,0,NULL, salary/sal_1) end)
end as annual_sal
from employee
group by emp_key,sal_1;

 

 

this is the right one..if anyone is interested..

ok