Topics Topics Help/Instructions Help Edit Profile Profile Member List Register Paatha Gnyapakaalu - Archives from Old DB  
Search New Posts 1 | 2 | 8 Hours Search New Posts 1 | 3 | 7 Days Search Search Tree View Tree View Latest tweets Live Tweets   Hide Images

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

    (Worst)    1    2    3    4    5     (Best)

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Ferrari
Mudiripoyina Bewarse
Username: Ferrari

Post Number: 10664
Registered: 09-2010
Posted From: 207.173.232.98

Rating: N/A
Votes: 0

Posted on Friday, February 28, 2014 - 3:27 pm:   
Proofdada:

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...



idi work avuddi mostly
Nandamuri Taraka Rama Rao - Sachin Ramesh Tendulkar

Topics | Last Hour | Last Day | Last Week | Tree View | Search | Help/Instructions | Program Credits Administration