| Author | Message | ||
     Goonda Megastar Username: Goonda Post Number: 22012 Registered: 02-2007 Posted From: 75.66.158.123 Rating: N/A |
You can also use COALESCE for more than 2 values COALESCE(Col1,Col2,col3, 0) returns first column that is not null. (Message edited by admin on November 03, 2012) Sasibabu: If TDP loses next elechens, i will donate 10% of my salary to TDP Skywalker: Bala chiru type kadu.....narasimha swamy avataram etti posani gadi pegulu medalo esukuntadu | ||
| Ruj Side Hero Username: Ruj Post Number: 7822 Registered: 03-2007 Posted From: 76.113.251.241 Rating: N/A |
perfect..will try..thanks.. Visalandhra book house, koti - one stop place for all telugu literature..(books,novels, literature etc).. | ||
| Goonda Megastar Username: Goonda Post Number: 22011 Registered: 02-2007 Posted From: 75.66.158.123 Rating: N/A |
why can't you use function COALESCE COALESCE(Col1,0) = return col1 if not NULL, 0 if NULL. Sasibabu: If TDP loses next elechens, i will donate 10% of my salary to TDP Skywalker: Bala chiru type kadu.....narasimha swamy avataram etti posani gadi pegulu medalo esukuntadu | ||
| Goonda Megastar Username: Goonda Post Number: 22010 Registered: 02-2007 Posted From: 75.66.158.123 Rating: N/A |
why can you use function COALESCE COALESCE(Col1,0) = return col1 if not NULL, 0 if NULL. Sasibabu: If TDP loses next elechens, i will donate 10% of my salary to TDP Skywalker: Bala chiru type kadu.....narasimha swamy avataram etti posani gadi pegulu medalo esukuntadu | ||
| Ruj Side Hero Username: Ruj Post Number: 7820 Registered: 03-2007 Posted From: 76.113.251.241 Rating: N/A |
nope Visalandhra book house, koti - one stop place for all telugu literature..(books,novels, literature etc).. | ||
| Ruj Side Hero Username: Ruj Post Number: 7819 Registered: 03-2007 Posted From: 76.113.251.241 Rating: N/A |
requirement ante peddha em ledu bhayya..actually its reporting side..replacing nulls with zeroes..alage showing values only for some specific flags..ala anamaata.. so using many case statements.. like case when A= 'Pass' then [Amount] else 0..ala... pt is..in oracle we used to use decode statements..as case adversly effects the performance.. ippudu pointing to teradata...so aa decode fn work avvatledu..so teradata lo emayina specific fns unnaya case ki alternative ga ani.. Visalandhra book house, koti - one stop place for all telugu literature..(books,novels, literature etc).. | ||
| Emc2 Side Hero Username: Emc2 Post Number: 9251 Registered: 03-2008 Posted From: 71.246.229.243 Rating: N/A |
target ki chesthunnava? cherapakura chedevu. | ||
| Outlaw Comedian Username: Outlaw Post Number: 1644 Registered: 02-2012 Posted From: 198.228.228.176 Rating: N/A |
Cast? | ||
| Goonda Megastar Username: Goonda Post Number: 22009 Registered: 02-2007 Posted From: 75.66.158.123 Rating: N/A |
nee requirement enti? Sasibabu: If TDP loses next elechens, i will donate 10% of my salary to TDP Skywalker: Bala chiru type kadu.....narasimha swamy avataram etti posani gadi pegulu medalo esukuntadu | ||
| Ruj Side Hero Username: Ruj Post Number: 7818 Registered: 03-2007 Posted From: 76.113.251.241 Rating: N/A |
kakunda inkemayina use cheyacha oracle lo decode laga..better performance ki.. Visalandhra book house, koti - one stop place for all telugu literature..(books,novels, literature etc).. |
