sql
Khóa học miễn phí SQL – Aggregate Functions nhận dự án làm có lương
SQL – Aggregate Functions
In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. SQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the SQL aggregate functions −
| Sr.No. | Function & Description |
|---|---|
| 1 |
Returns the approximate number of rows with distinct expression values. |
| 3 |
Returns the checksum value. |
| 4 |
Returns the count of the number of items or rows selected by the select statement. |
| 6 |
Returns whether the specified column expression in a group by list is aggregate or not. |
| 7 |
Returns the level of grouping. |
| 10 |
Returns the statistical standard deviation of the fields (numerical values) in a particular column. |
| 11 |
Returns the population standard deviation for the fields (numerical values) in a particular column. |
| 13 |
Returns the statistical standard variance of the fields (numerical values) in a particular column. |
| 14 |
Returns the population standard variance of the fields (numerical values) in a particular column. |
Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc
