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: 134117 Registered: 03-2004 Posted From: 72.54.157.179 Rating: N/A Votes: 0 Posted on Friday, February 28, 2014 - 3:25 pm:    SUM(CASE WHEN Persons.Name = 'John' THEN 1 ELSE 0 END) AS JohnCount, SUM(CASE WHEN Persons.Name = 'John' AND Persons.Age > 30 THEN 1 ELSE 0 END) AS OldJohnsCount, COUNT(*) AS AllPersonsCount idedhedho dorkindhi meeting tharuvatha ee model fallow aytha... Narsiah fans Ramu,Gali...