RcBuilder@walla.com
call centre: 054-5614020

SQL aggregation with NULL values

Posted by: RcBuilder  /   Category: Aggregation / DBA / SQL   /   No Comments
28
May
2014

SQL aggregation functions with null values all aggregation sql functions count only non null rows!! therefore, we can use this rule in order to filter out unwanted rows examples: // sum only firstDeposit rows SUM(case when firstDeposit = 0 then null else USDValue end) // count only firstDeposit rows // if firstDeposit = 0 return NULL COUNT(NULLIF(0,.

Read more
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים