MySQL COUNT() Function

MySQL COUNT() Function Example Return the number of products in the “Products” table: SELECT COUNT(ProductID) AS NumberOfProducts FROM Products; Definition

MySQL COALESCE() Function

MySQL COALESCE() Function Example Return the first non-null value in a list: SELECT COALESCE(NULL, NULL, NULL, ‘W3Schools.com’, NULL, ‘Example.com’); Definition