Snow Brothers Sunny Leone Ni Esara..

[pachimirchi]

 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;

 

[babugaru]

solved or need help still?

ledhu

[spidereddy]

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]

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]

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]

 

 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..

[Sona_Parv001]

snow sister kuda esindi.

[babugaru]

looks convincing..let me try it..

NULL unnappudu pakkaga tantundi kada bhayya ala aithe 

[babugaru]

snow sister kuda esindi.

ROFL 

[Uchiha]

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]

snow sister kuda esindi.

Hahahaha super baaa

[spidereddy]

NULL unnappudu pakkaga tantundi kada bhayya ala aithe 

try cheshi cheptha..stay tuned

[Posaani]

Yes man threesome anta
Idhi enti daani rate details ?

4 some ayite nenu join ayita..
It will be awesome you no.

[Posaani]

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]

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