| 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" clause | Fahim Mohammad | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Fayaz Yusuf Khan | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Fahim Mohammad | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Nuno Tavares | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Claudio Nanni | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Claudio Nanni | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Fahim Mohammad | 11 Jun |
| • Re: How to find values which do not return any tuple in "IN" clause | Nuno Tavares | 11 Jun |
