Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Proofdada Bewarse Legend Username: Proofdada Post Number: 134110 Registered: 03-2004 Posted From: 72.54.157.179 Rating: N/A Votes: 0 Posted on Friday, February 28, 2014 - 3:13 pm:    select count(items), count(closeddate is not null) from items where xxxxx(some condition with dates) basic ga aa closed date not null count correct ga ravali kaani adhi number of closed date rows ichesthandhi, it means items count and closed dates count okate isthandhi... neenu rasindhi thappe kaani, aa option etta rayatam oka query loone I need all item counts, and count of closed date not null kaavali.... where clause loo aa not null option pettaleemu...ekkada ettali etta ettalooo soopinchundri ettestha... Narsiah fans Ramu,Gali...