COUNT variations (*,col,DISTINCT)

Concepts: sqlCount, sqlCountDistinct

COUNT Variations COUNT(*) - Count All Rows COUNT(column) Consider a table where some customers have not provided an email: COUNT(DISTINCT) 1,847 orders came from 892 unique customers. This tells you that some customers placed multiple orders. Practical Applications Comparing COUNT Variants Database Execution