puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 subquery lo outer query lo unna user tho validate cheyali, ledante outer query lo prathi row ki inner query lo table mottam validate chestadi, not effective. Also, NOT IN kante not exists use cheyadam better performance antaaru. cool.. nenu edo paina paina sql.. we use sql but edhi better in performance antha idea ledu :3D_Smiles_56: .. rest/soap wcf and azure mathrame better idea undi Link to comment Share on other sites More sharing options...
SwamyRaRa Posted July 29, 2014 Report Share Posted July 29, 2014 isnumeric ani vuntadhi sql lo ............... Link to comment Share on other sites More sharing options...
SUbba LIngam Posted July 29, 2014 Report Share Posted July 29, 2014 size batti man .. small sets ki ok general ga prathi table lo bagane untadi kada data,,,,,,,, nenu ayithe evaina harcoded values validation ki matrame use chesta NOT IN Link to comment Share on other sites More sharing options...
ChampakDas Posted July 29, 2014 Report Share Posted July 29, 2014 ante? select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY not like '%[0-9]%' ./// idhi user konna numeric category product theesi albhabet category konnadhi ni isthe .. :( Link to comment Share on other sites More sharing options...
puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 ardam kale evaranna nannu quote chesthe notification ravali ani theddu vesa and settings changed and you are first one to quote me after setting change Link to comment Share on other sites More sharing options...
puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 @KaatiKapari naa query ni nuvvu cheppina prakaram optimize karke idhar paste kar Link to comment Share on other sites More sharing options...
JollyBoy Posted July 29, 2014 Report Share Posted July 29, 2014 evaranna nannu quote chesthe notification ravali ani theddu vesa and settings changed and you are first one to quote me after setting change Link to comment Share on other sites More sharing options...
SUbba LIngam Posted July 29, 2014 Report Share Posted July 29, 2014 @KaatiKapari naa query ni nuvvu cheppina prakaram optimize karke idhar paste kar nuv vesina post paina ne undi man, chudu. Link to comment Share on other sites More sharing options...
tejak123 Posted July 29, 2014 Author Report Share Posted July 29, 2014 SELECT DISTINCT useridFROM temptableWHERE userid NOT IN ( SELECT DISTINCT userid FROM temptable WHERE PRODUCT_BOUGHT_CATEGORY LIKE '%[0-9]%' )./// Error...cannot recognise select, distinct, userid in expression specification ani error vasthundhi bhaiya Link to comment Share on other sites More sharing options...
SUbba LIngam Posted July 29, 2014 Report Share Posted July 29, 2014 cool.. nenu edo paina paina sql.. we use sql but edhi better in performance antha idea ledu .. rest/soap wcf and azure mathrame better idea undi naku bhi em raadu mayya, asalu first job ekkemundu varaku database ante kuda idea lekunde :3D_Smiles_56: Link to comment Share on other sites More sharing options...
puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 SELECT DISTINCT useridFROM temptableWHERE userid NOT IN ( SELECT DISTINCT userid FROM temptable WHERE PRODUCT_BOUGHT_CATEGORY LIKE '%[0-9]%' )./// Error...cannot recognise select, distinct, userid in expression specification ani error vasthundhi bhaiya nenu temptable ani create cheskoni test chesa.. change table column names Link to comment Share on other sites More sharing options...
ChampakDas Posted July 29, 2014 Report Share Posted July 29, 2014 this was the same argument that came up last week with an architect..I defended it saying both are same performance(and its true they are same at least it is justified based on the execution plan) but it is advisable because its more clear to the second eye what the intention is and sometimes not in works weirdly based on the column property..grammar thapul unte kshminchu asal ardam lekunte marninchu subquery lo outer query lo unna user tho validate cheyali, ledante outer query lo prathi row ki inner query lo table mottam validate chestadi, not effective. Also, NOT IN kante not exists use cheyadam better performance antaaru. Link to comment Share on other sites More sharing options...
ganesh Posted July 29, 2014 Report Share Posted July 29, 2014 Select user from tablename where LENGTH(TRIM(TRANSLATE(product_brought_category', ' +-.0123456789',' '))) !>1This should work i guess Link to comment Share on other sites More sharing options...
puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 this was the same argument that came up last week with an architect..I defended it saying both are same performance(and its true they are same at least it is justified based on the execution plan) but it is advisable because its more clear to the second eye what the intention is and sometimes not in works weirdly based on the column property..grammar thapul unte kshminchu asal ardam lekunte marninchu Link to comment Share on other sites More sharing options...
puli_keka Posted July 29, 2014 Report Share Posted July 29, 2014 Select user from tablename where LENGTH(TRIM(TRANSLATE(product_brought_category', ' +-.0123456789',' '))) is not null... This should work i guess <> meeda click chesi code paste chey when you edit and select SQL Link to comment Share on other sites More sharing options...
Recommended Posts