pachimirchi Posted October 23, 2014 Report 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;
spidereddy Posted October 23, 2014 Author Report 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;
pandugadu999 Posted October 23, 2014 Report 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,,
spidereddy Posted October 23, 2014 Author Report 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..
spidereddy Posted October 23, 2014 Author Report 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..
babugaru Posted October 23, 2014 Report Posted October 23, 2014 looks convincing..let me try it.. NULL unnappudu pakkaga tantundi kada bhayya ala aithe
Uchiha Posted October 23, 2014 Report 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
Nice_Guy Posted October 23, 2014 Report Posted October 23, 2014 snow sister kuda esindi. Hahahaha super baaa
spidereddy Posted October 23, 2014 Author Report Posted October 23, 2014 NULL unnappudu pakkaga tantundi kada bhayya ala aithe try cheshi cheptha..stay tuned
Posaani Posted October 23, 2014 Report 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.
Posaani Posted October 23, 2014 Report 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.
siru Posted October 23, 2014 Report 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
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts