Home >> MySql >> CHECKSUM_AGG() aggregate function in MySql

CHECKSUM_AGG() aggregate function in MySql

Find the checksum of the values in a group. Null values are ignored.

CHECKSUM_AGG ( [ ALL | DISTINCT ] expression )

ALL
Applies the aggregate function to all values. ALL is the default.

DISTINCT
Specifies that CHECKSUM_AGG returns the checksum of unique values.

expression
Is an integer expression. Aggregate functions and subqueries are not allowed.

Post Your Comment

Next Questions
ABS(n) aggregate function
POWER(m,n) aggregate function
ROUND() aggregate function
SQRT() aggregate function
GREATEST() aggregate function
LEAST() aggregate function
EXP() aggregate function
EXTRACT() aggregate function
MOD() aggregate function
TRUNC() aggregate function
FLOOR() aggregate function
CEIL() aggregate function
FIRST() aggregate function
LAST() aggregate function
MID() aggregate function
LEN() aggregate function
NOW() aggregate function
FORMAT() aggregate function
COUNT() aggregate function
LOWER() aggregate function
UPPER() aggregate function
INITCAP() aggregate function
SUBSTR() aggregate function
ASCII() aggregate function
LENGTH() aggregate function

Copyright ©2022 coderraj.com. All Rights Reserved.