babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 2nd query chudu.. WHEN sal_1 <> 0 AND sal_1 is not NULL idi try cheyyi second query lo Link to comment Share on other sites More sharing options...
Johny Posted October 23, 2014 Report Share Posted October 23, 2014 delete evryfrocking single thing from tbl_name ; Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 ltt Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title Link to comment Share on other sites More sharing options...
ipaddress0 Posted October 23, 2014 Report Share Posted October 23, 2014 Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title avun chala disappoint ayina Link to comment Share on other sites More sharing options...
sompapidi Posted October 23, 2014 Report Share Posted October 23, 2014 ltt help spidereddy and sunny leone bye1 bye1 Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 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.. Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 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; Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 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.. Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 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 Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 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 Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 adhi possible antava... nu nan erri fruit ni cheyatle kada.. oka column lo 0 undatam veru NULL value undatam veru bhayya .. adi matram pakka Link to comment Share on other sites More sharing options...
pandugadu999 Posted October 23, 2014 Report Share Posted October 23, 2014 brothers emo gaani..father esi untad man Link to comment Share on other sites More sharing options...
spidereddy Posted October 23, 2014 Author Report Share Posted October 23, 2014 brothers emo gaani..father esi untad man sullri cut ayi okad edisthe aathrulu cut ayi okad edchadanta.. evadesthe manakendhi bhayya.. Link to comment Share on other sites More sharing options...
papacha Posted October 23, 2014 Report Share Posted October 23, 2014 solved or need help still? Link to comment Share on other sites More sharing options...
babugaru Posted October 23, 2014 Report Share Posted October 23, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts