List:General Discussion« Previous MessageNext Message »
From:Fahim Mohammad Date:June 10 2011 10:36pm
Subject:How to find values which do not return any tuple in "IN" clause
View as plain text  
Hi

select * from  tablename where fieldname in ('aaa','bbb','ccc','ddd');

return only the successful hit.

How can I know how many out of four ('aaa','bbb','ccc','ddd') resulted in a
miss OR which values do not return any tuple.

Thanks

Fahim

Thread
How to find values which do not return any tuple in "IN" clauseFahim Mohammad11 Jun
  • Re: How to find values which do not return any tuple in "IN" clauseFayaz Yusuf Khan11 Jun
    • Re: How to find values which do not return any tuple in "IN" clauseFahim Mohammad11 Jun
  • Re: How to find values which do not return any tuple in "IN" clauseNuno Tavares11 Jun
  • Re: How to find values which do not return any tuple in "IN" clauseClaudio Nanni11 Jun
    • Re: How to find values which do not return any tuple in "IN" clauseClaudio Nanni11 Jun
Re: How to find values which do not return any tuple in "IN" clauseFahim Mohammad11 Jun
  • Re: How to find values which do not return any tuple in "IN" clauseNuno Tavares11 Jun