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.