call centre: 054-5614020

SQL aggregation with NULL values

Posted by: RcBuilder  /   Category: Aggregation / DBA / SQL   /   No Comments

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
  • פיתוח מערכות
  • פתרונות טכנולוגים
  • קידום אתרים
  • בניית אתרים