spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 avna..inni rojulu sunny gurinchi thappu ga ankunna...ee sari kanipiste personal ga apology cheppukovalani vundi apooklogy chepthava.. Link to comment Share on other sites More sharing options...
Nellore Pedda reddy Posted October 23, 2014 Report Share Posted October 23, 2014 Ee subject teleenodu open chesina enti upayogam Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 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_salfrom employeegroup by emp_key,sal_1; this is the right one..if anyone is interested.. Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 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_salfrom employeegroup by emp_key,sal_1; this is the right one..if anyone is interested.. ok Link to comment Share on other sites More sharing options...
Recommended Posts