babugaru Posted October 23, 2014 Report Posted October 23, 2014 2nd query chudu.. WHEN sal_1 <> 0 AND sal_1 is not NULL idi try cheyyi second query lo
Johny Posted October 23, 2014 Report Posted October 23, 2014 delete evryfrocking single thing from tbl_name ;
babugaru Posted October 23, 2014 Report Posted October 23, 2014 ltt Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title
ipaddress0 Posted October 23, 2014 Report Posted October 23, 2014 Sunny Leone anagane agabadi lopaliki occhinattu unnav .. mana Spiderreddy manchi intelligent ga pettadu title avun chala disappoint ayina
sompapidi Posted October 23, 2014 Report Posted October 23, 2014 ltt help spidereddy and sunny leone bye1 bye1
spidereddy Posted October 23, 2014 Author Report 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..
babugaru Posted October 23, 2014 Report 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;
spidereddy Posted October 23, 2014 Author Report 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..
babugaru Posted October 23, 2014 Report 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
spidereddy Posted October 23, 2014 Author Report 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
babugaru Posted October 23, 2014 Report 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
pandugadu999 Posted October 23, 2014 Report Posted October 23, 2014 brothers emo gaani..father esi untad man
spidereddy Posted October 23, 2014 Author Report Posted October 23, 2014 brothers emo gaani..father esi untad man sullri cut ayi okad edisthe aathrulu cut ayi okad edchadanta.. evadesthe manakendhi bhayya..
babugaru Posted October 23, 2014 Report 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
.thumb.jpg.ce42bb16ec102475a78c2087ce269c7d.jpg)
Recommended Posts