页次: 1
min(), max(), avg(), count(), sum()
mysql> create table tb_1 ( n int ); Query OK, 0 rows affected (0.08 sec) mysql> insert into tb_1 (n) values (1), (2), (3), (4); Query OK, 4 rows affected (0.06 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> select min(n) from tb_1; +--------+ | min(n) | +--------+ | 1 | +--------+ 1 row in set (0.03 sec) mysql> select avg(n) from tb_1; +--------+ | avg(n) | +--------+ | 2.5000 | +--------+ 1 row in set (0.01 sec)
ipbbs.net
离线
页次: 1