Aggregate Functions How to handle NULL



I use the sql scripts above to insert some data into another table, the system show the 'warning' message (inside the red rectangle) to me. I found the 'aggregation function' would eliminate the 'NULL' .

For example:

count(id), the value you will get is 4, but count(createuser), the value you will get is 3

原文地址:https://www.cnblogs.com/wildboar/p/2091148.html