0
0
Mitul Dabhi
answered Nov 30 '-1 00:00
SQLite
avg() , count() , group_concat() , max() , min() , sum() is the Aggregate Functions in SQLite .
avg() :: mostly find the average of group values .
count() :: mostly count of occurrence of value.
group_concat() :: it used for group concatenation .
max() :: its find max value from given values.
min() :: its find min value from given values.
sum() :: its give sum of given values.
total() :: its give total of given values.
MySQL
MySQL have Aggregate Functions :: avg() , count() , group_concat() , max() , min() , sum() as SQLite have and additional following Aggregate function.
BIT_AND() :: Return bitwise AND
BIT_OR() :: Return bitwise OR
BIT_XOR() :: Return bitwise XOR
STD() :: Return the population standard deviation
STDDEV() :: Return the population standard deviation
STDDEV_POP() :: Return the population standard deviation
STDDEV_SAMP() :: Return the sample standard deviation
VAR_POP() :: Return the population standard variance
VAR_SAMP() :: Return the sample variance
VARIANCE() :: Return the population standard variance