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
signature.asc
Description: This is a digitally signed message part.
