tejak123 Posted July 29, 2014 Report Share Posted July 29, 2014 USER | PRODUCT_BOUGHT_CATEGORY A | YUI B | JHI C | WER E | 123 A | 456 C | DFG B | CFT E | 365 S | ASD H | HJK E | ASD How can i get users who bought atleast one ALPHABET category product and didnt buy numeric Category products..?? my output should be B C S H chi. neku idhi kuda raaadha ani thittttukokunda.. cheppandi boss.. :( Link to comment Share on other sites More sharing options...
ZuniorVentiyar Posted July 29, 2014 Report Share Posted July 29, 2014 ila endhuku thittukuntaru anna ..... LTT for jambalheart USER | PRODUCT_BOUGHT_CATEGORY A | YUI B | JHI C | WER E | 123 A | 456 C | DFG B | CFT E | 365 S | ASD H | HJK E | ASD How can i get users who bought atleast one ALPHABET category product and didnt buy numeric Category products..?? my output should be B C S H chi. neku idhi kuda raaadha ani thittttukokunda.. cheppandi boss.. :( Link to comment Share on other sites More sharing options...
JollyBoy Posted July 29, 2014 Report Share Posted July 29, 2014 maya store procedure lo rayali emo .. query kavala Link to comment Share on other sites More sharing options...
pandugadu999 Posted July 29, 2014 Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' Link to comment Share on other sites More sharing options...
tejak123 Posted July 29, 2014 Author Report Share Posted July 29, 2014 maya store procedure lo rayali emo .. query kavala..// :) Link to comment Share on other sites More sharing options...
tejak123 Posted July 29, 2014 Author Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' /// What if this user bought both alphabet and numerical... We dont want him Link to comment Share on other sites More sharing options...
JollyBoy Posted July 29, 2014 Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' oka user ki product alpha bet and number unte idi workout kadu Link to comment Share on other sites More sharing options...
k2s Posted July 29, 2014 Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' maya store procedure lo rayali emo .. query kavala..// :) Link to comment Share on other sites More sharing options...
pandugadu999 Posted July 29, 2014 Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' and not like '%[0-9]%' select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' /// What if this user bought both alphabet and numerical... We dont want him Link to comment Share on other sites More sharing options...
JollyBoy Posted July 29, 2014 Report Share Posted July 29, 2014 Link to comment Share on other sites More sharing options...
JollyBoy Posted July 29, 2014 Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' and not like '%[0-9]%' work avvadu ba.. Link to comment Share on other sites More sharing options...
ramu Posted July 29, 2014 Report Share Posted July 29, 2014 Not exists condition add cheyyi bhayya aa pina query ki Link to comment Share on other sites More sharing options...
tejak123 Posted July 29, 2014 Author Report Share Posted July 29, 2014 select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' and not like '%[0-9]%' ..//// thanks ... chustha bhaiya... Link to comment Share on other sites More sharing options...
pandugadu999 Posted July 29, 2014 Report Share Posted July 29, 2014 chinna mistake select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' and PRODUCT_BOUGHT_CATEGORY not like '%[0-9]%' select distinct USER from table_name where PRODUCT_BOUGHT_CATEGORY like '%[a-z]%' and not like '%[0-9]%' ..//// thanks ... chustha bhaiya... Link to comment Share on other sites More sharing options...
pandugadu999 Posted July 29, 2014 Report Share Posted July 29, 2014 work avvadu ba.. y re...ill work Link to comment Share on other sites More sharing options...
Recommended Posts