Simple Sql Query Doubt

[tejak123]

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

 

[ZuniorVentiyar]

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

 

[JollyBoy]

maya store procedure lo rayali emo .. query kavala

[pandugadu999]

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY like  '%[a-z]%'     

[tejak123]

maya store procedure lo rayali emo .. query kavala..//

 

:)

[tejak123]

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 

[JollyBoy]

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

[k2s]

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY like  '%[a-z]%'     

 

 

maya store procedure lo rayali emo .. query kavala..//

 

:)

[pandugadu999]

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 

 

[JollyBoy]

 

 

 

[JollyBoy]

 

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY like  '%[a-z]%'    and  not like   '%[0-9]%' 

 

 

work avvadu ba..

[ramu]

Not exists condition add cheyyi bhayya aa pina query ki

[tejak123]

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY like  '%[a-z]%'    and  not like   '%[0-9]%' ..////

 

thanks ... chustha bhaiya...

 

 

[pandugadu999]

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

 

 

[pandugadu999]

work avvadu ba..

 

y re...ill work