I am looking for those values (or count of those values) which do not
resulted in a hit.
Thanks
Fahim
On Fri, Jun 10, 2011 at 7:17 PM, Fayaz Yusuf Khan <fa...@dexetra.com> wrote:
> On Saturday 11 Jun 2011 4:06:27 AM Fahim Mohammad wrote:
> > select * from tablename where fieldname in ('aaa','bbb','ccc','ddd');
> > 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.
> Perhaps this would be what you're looking for?
> "SELECT fieldname,COUNT(*) FROM tablename WHERE fieldname IN
> ('aaa','bbb','ccc','ddd') GROUP BY fieldname;"
>
> --
> Fayaz Yusuf Khan
> Cloud developer and designer in Python/AppEngine platform
> Dexetra Software Solutions Pvt. Ltd., Kochi, Kerala, India
> B.Tech. Computer Science & Engineering (2007-2011)
> Model Engineering College, Kochi, Kerala, India
> Registered Linux user #484201
> fayaz.yusuf.k...@gmail.com
> fa...@dexetra.com
> +91-9746-830-823
>
