pachimirchi Posted October 23, 2014 Report Share Posted October 23, 2014 select case when sal_1=0 then 0 else sum(case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char(sysdate,'YYYYMM') then salary/sal_1 end)end as annual_sal from employee group by emp_key,sal_1; or select sum(case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char(sysdate,'YYYYMM') then (salary/(case when sal_1!=0 then sal_1 else NULL end)) end) annual_sal from employee group by emp_key,sal_1; Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 solved or need help still? ledhu Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 positive case ki work ayyindhi annav kada aan query okasari cheepi select case when sal_1<>0 then sum(case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char(sysdate,'YYYYMM') then salary/sal_1 end)end as annual_sal from employee where sal_1 > 0 group by emp_key,sal_1; Link to comment Share on other sites More sharing options...
pandugadu999 Posted October 23, 2014 Report Share Posted October 23, 2014 sullri cut ayi okad edisthe aathrulu cut ayi okad edchadanta.. evadesthe manakendhi bhayya.. mari aa title pettindi nuvve kada maayyaa...sakkaga sql query help ani pedthe help sestar kada vaa,, Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 mari aa title pettindi nuvve kada maayyaa...sakkaga sql query help ani pedthe help sestar kada vaa,, try cheshna atla kuda..evad reply ichi savale.. sarle nu feel avvaku..aa sollu kuda eskundhamm.. manalo mana mata..sunny leone aa moddralanu eda dhekthadhi bhayya.. Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 select case when sal_1=0 then 0 else sum(case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char(sysdate,'YYYYMM') then salary/sal_1 end)end as annual_sal from employee group by emp_key,sal_1; or select sum(case when date_key between to_char(add_months(sysdate,-12),'YYYYMM') and to_char(sysdate,'YYYYMM') then (salary/(case when sal_1!=0 then sal_1 else NULL end)) end) annual_sal from employee group by emp_key,sal_1; looks convincing..let me try it.. Link to comment Share on other sites More sharing options...
Sona_Parv001 Posted October 23, 2014 Report Share Posted October 23, 2014 snow sister kuda esindi. Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 looks convincing..let me try it.. NULL unnappudu pakkaga tantundi kada bhayya ala aithe Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 snow sister kuda esindi. ROFL Link to comment Share on other sites More sharing options...
Uchiha Posted October 23, 2014 Report Share Posted October 23, 2014 eyaledu bhayya... adi dani mogudi tho tappithe evritho em cheyadu..ade cheppindi okasari.. danivi motham 4 men tho untay videos... okadu first engagment ayinodu taruvatha cancel ayindi engagement.. madhyalo 2 ritho chesindi..inka migatha cinemalu anni moguditho ne... porn stars lo pathivratha sunny Link to comment Share on other sites More sharing options...
Nice_Guy Posted October 23, 2014 Report Share Posted October 23, 2014 snow sister kuda esindi. Hahahaha super baaa Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 NULL unnappudu pakkaga tantundi kada bhayya ala aithe try cheshi cheptha..stay tuned Link to comment Share on other sites More sharing options...
Posaani Posted October 23, 2014 Report Share Posted October 23, 2014 Yes man threesome anta Idhi enti daani rate details ? 4 some ayite nenu join ayita.. It will be awesome you no. Link to comment Share on other sites More sharing options...
Posaani Posted October 23, 2014 Report Share Posted October 23, 2014 eyaledu bhayya... adi dani mogudi tho tappithe evritho em cheyadu..ade cheppindi okasari.. danivi motham 4 men tho untay videos... okadu first engagment ayinodu taruvatha cancel ayindi engagement.. madhyalo 2 ritho chesindi..inka migatha cinemalu anni moguditho ne... porn stars lo pathivratha sunny Née g yem kaadoo. Neelanti yerri pappa vunte yennayinaa cheppuddi. Nuvvu chesuko anniyya.. Vodina chaalaa manchidi. Link to comment Share on other sites More sharing options...
siru Posted October 23, 2014 Report Share Posted October 23, 2014 eyaledu bhayya... adi dani mogudi tho tappithe evritho em cheyadu..ade cheppindi okasari.. danivi motham 4 men tho untay videos... okadu first engagment ayinodu taruvatha cancel ayindi engagement.. madhyalo 2 ritho chesindi..inka migatha cinemalu anni moguditho ne... porn stars lo pathivratha sunny avna..inni rojulu sunny gurinchi thappu ga ankunna...ee sari kanipiste personal ga apology cheppukovalani vundi Link to comment Share on other sites More sharing options...
Recommended Posts