Simple Sql Query Doubt

[SUbba LIngam]

select  distinct  a.USER  from table_name a

where  instr(a.PRODUCT_BOUGHT_CATEGORY) like  '%[a-z]%' and not exists (select 'x' from table_name b

where  a.user=b.user and instr(b.PRODUCT_BOUGHT_CATEGORY) like '%[0-9]%')

 

idi try chesi chudu okasari, not sure abt 'like' results,,,,,,,,,, intikellaaka okasari manchiga think chesi cheptaa.

[JollyBoy]

y re...ill work

 

okasari rasi chudu ba.. work avadu.. multiple statememts kavali

 

A  |  123

A  |  xyz

 

 

ne query above condition lo A user tesuku vastadi
 

[puli_keka]

SELECT DISTINCT userid
FROM temptable
WHERE userid NOT IN (
		SELECT DISTINCT userid
		FROM temptable
		WHERE PRODUCT_BOUGHT_CATEGORY LIKE '%[0-9]%'
		)

 

change column names :)

[JollyBoy]

 

SELECT DISTINCT userid
FROM temptable
WHERE userid NOT IN (
		SELECT DISTINCT userid
		FROM temptable
		WHERE PRODUCT_BOUGHT_CATEGORY LIKE '%[0-9]%'
		)

 

change column names :)

 

 

+1 grp by avi pettuko.. nenu ekuva think chesa

 

[puli_keka]

+1 grp by avi pettuko.. nenu ekuva think chesa

 

 

?? 

 

BTW i just got notification that you quoted me.. naa settings update for this notification is tested and signed off 

[pandugadu999]

simple ga   idi panichestadi ga......vadu only numeric vadu annadu

so

 

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY   not like   '%[0-9]%' 

[SUbba LIngam]

 

SELECT DISTINCT userid
FROM temptable
WHERE userid NOT IN (
		SELECT DISTINCT userid
		FROM temptable
		WHERE PRODUCT_BOUGHT_CATEGORY LIKE '%[0-9]%'
		)

 

change column names :)

 

 

 

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.

[pandugadu999]

okasari rasi chudu ba.. work avadu.. multiple statememts kavali

 

A  |  123

A  |  xyz

 

 

ne query above condition lo A user tesuku vastadi
 

correste...aithe this works....

 

 

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY  not like   '%[0-9]%' 

[SUbba LIngam]

 

simple ga   idi panichestadi ga......vadu only numeric vadu annadu

so

 

select  distinct  USER  from table_name

where  PRODUCT_BOUGHT_CATEGORY   not like   '%[0-9]%' 

 

 

no man, this may return rows that can have both char and num data.

[JollyBoy]

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.

 

size batti man .. small sets ki ok

[tejak123]

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

[JollyBoy]

?? 

 

BTW i just got notification that you quoted me.. naa settings update for this notification is tested and signed off 

 

ardam kale

[JollyBoy]

 

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

 

hoouse stark di use chey

[tejak123]

 

size batti man .. small sets ki ok..//

 

I work for Big Data bhaiya :O

[SUbba LIngam]

 

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

 

 

 

paina vere sql suggest chesam kada vay emaindi try cheyaleda