Community Member Profile
Dan Farrell
Member since Dec 29, 2010
- Profile: /members/7517-Dan-Farrell.htm
- URL: danf.us
- Comments: 1
- Points: 12
Recent Blog Comments By Dan Farrell
-
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
Posted on Dec 29, 2010 at 9:49 PM
>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 For the record, a better way to do conditionals inside sums and counts might be: su... read more »
