Simple Sql Query Doubt

[puli_keka]

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 

[SwamyRaRa]

isnumeric ani vuntadhi sql lo ...............

[SUbba LIngam]

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

[ChampakDas]

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 .. :(

 

 

[puli_keka]

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 

[puli_keka]

@KaatiKapari    naa query ni nuvvu cheppina prakaram optimize karke idhar paste kar

[JollyBoy]

evaranna nannu quote chesthe notification ravali ani theddu vesa and settings changed and you are first one to quote me after setting change 

 

[SUbba LIngam]

@KaatiKapari    naa query ni nuvvu cheppina prakaram optimize karke idhar paste kar

 

nuv vesina post paina ne undi man, chudu.

[tejak123]

SELECT DISTINCT userid
FROM temptable
WHERE 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

[SUbba LIngam]

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:

[puli_keka]

SELECT DISTINCT userid
FROM temptable
WHERE 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 

[ChampakDas]

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.

 

[ganesh]

Select user from tablename where LENGTH(TRIM(TRANSLATE(product_brought_category', ' +-.0123456789',' '))) !>1This should work i guess

[puli_keka]

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

 

[puli_keka]

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