SQLite 常用函数

内置函数速览：count/max/min/avg/sum 聚合，abs/round 数学，upper/lower/length/substr 字符串。

Beginner

Key PointsSQLite,函数,聚合,字符串

讲解

内置函数速览：count/max/min/avg/sum 聚合，abs/round 数学，upper/lower/length/substr 字符串。

SQL

SELECT count(*) FROM company;
SELECT upper(name), length(name) FROM company;
SELECT max(age), min(age), avg(age) FROM company;

Output

5
GOOGLE|6
30|20|25.0

内置函数速览：count/max/min/avg/sum 聚合，abs/round 数学，upper/lower/length/substr 字符串。

SQL

SELECT count(*) FROM company;
SELECT upper(name), length(name) FROM company;
SELECT max(age), min(age), avg(age) FROM company;

Output

5
GOOGLE|6
30|20|25.0