Machine Learning

Machine Learning

#aggregate-function

Articles tagged with #aggregate-function

Count(*) vs Count(column_name)
Count(*) vs Count(columng_name) In SQL, COUNT(column_name) and COUNT(*) are both used with the COUNT function, but they have different behaviors: COUNT(column_name): This form of COUNT counts the number of non-null values in the specified column. ...
Nov 27, 20232 min read2
Functions In SQL
Introduction Functions in SQL are divided into parts Built-in functions and User Defined functions Built In functions can be further categorized as scalar, aggregate functions Scalar Functions: In SQL, a scalar function is a function that takes o...
Jul 25, 20235 min read2