Snow Brothers Sunny Leone Ni Esara..

[babugaru]

2nd query chudu..

WHEN sal_1 <> 0 AND sal_1 is not NULL

 

idi try cheyyi second query lo

[Johny]

delete evryfrocking single thing from tbl_name ;

[babugaru]

ltt

Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title

[ipaddress0]

Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title

avun chala disappoint ayina 

[sompapidi]

ltt help spidereddy and sunny leone bye1 bye1

[spidereddy]

WHEN sal_1 <> 0 AND sal_1 is not NULL

 

idi try cheyyi second query lo

 

adhedho me chethultho meere raasisthe..nen dhinchestha ofc lo..

[babugaru]

adhedho me chethultho meere raasisthe..nen dhinchestha ofc lo..

bhayya 'meere' oddule .. antha respect oddhu .. nenu recent ga nerchukunna sql .. please _/\_

 

idi try chesi cheppu 

 

SELECT   CASE

                 WHEN sal_1 <> 0 AND sal_1 is not NULL

                 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

   GROUP BY   emp_key, sal_1;

[spidereddy]

 

bhayya 'meere' oddule .. antha respect oddhu .. nenu recent ga nerchukunna sql .. please _/\_

 

idi try chesi cheppu 

 

SELECT   CASE

                 WHEN sal_1 <> 0 AND sal_1 is not NULL

                 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

   GROUP BY   emp_key, sal_1;

 

adhi possible antava...

nu nan erri fruit ni cheyatle kada..

[babugaru]

adhedho me chethultho meere raasisthe..nen dhinchestha ofc lo..

Query mottam ikkada ledhu anukunta .. group by clause pettav but pina aggregate functions levu kada query tantundi malli

[spidereddy]

 

bhayya 'meere' oddule .. antha respect oddhu .. nenu recent ga nerchukunna sql .. please _/\_

 

idi try chesi cheppu 

 

SELECT   CASE

                 WHEN sal_1 <> 0 AND sal_1 is not NULL

                 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

   GROUP BY   emp_key, sal_1;

 

 

first emo small letters nundi caps loki marchi pampinchav query ni..

tarvatha and antav na bondha antav..

 

na prob negative values tho ante..nu edho chepthav..

 

null, zero pakana pettu..nen handle cheskunta..

 

>0 ki query is working..

 

<0 ki not working..

 

ipd solution chepu

[babugaru]

adhi possible antava...

nu nan erri fruit ni cheyatle kada..

oka column lo 0 undatam veru NULL value undatam veru bhayya .. adi matram pakka 

[pandugadu999]

brothers emo gaani..father esi untad man 

[spidereddy]

brothers emo gaani..father esi untad man 

 

sullri cut ayi okad edisthe aathrulu cut ayi okad edchadanta.. 

 

evadesthe manakendhi bhayya..

[papacha]

solved or need help still?

[babugaru]

first emo small letters nundi caps loki marchi pampinchav query ni..

tarvatha and antav na bondha antav..

 

na prob negative values tho ante..nu edho chepthav..

 

null, zero pakana pettu..nen handle cheskunta..

 

>0 ki query is working..

 

<0 ki not working..

 

ipd solution chepu

positive case ki work ayyindhi annav kada aan query okasari cheepi