Community Member Profile
Pedro
Member since Sep 14, 2009
- Profile: /members/4315-Pedro.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Pedro
-
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
Posted on Sep 14, 2009 at 6:51 PM
Just amazing, I did something like this: SELECT sum(case when paytype = 1 then amount else 0 end) as bpay, sum(case when paytype = 2 then amount else 0 end) as paypal, sum(case when paytype = 3 then amount else 0 end) as ccard FROM payments WHERE fkclientid = 20... read more »
