聚合
在模型中也可以調(diào)用數(shù)據(jù)庫的聚合方法進(jìn)行查詢，例如：
| 方法 | 說明 |
|---|---|
| count | 統(tǒng)計(jì)數(shù)量，參數(shù)是要統(tǒng)計(jì)的字段名（可選） |
| max | 獲取最大值，參數(shù)是要統(tǒng)計(jì)的字段名（必須） |
| min | 獲取最小值，參數(shù)是要統(tǒng)計(jì)的字段名（必須） |
| avg | 獲取平均值，參數(shù)是要統(tǒng)計(jì)的字段名（必須） |
| sum | 獲取總分，參數(shù)是要統(tǒng)計(jì)的字段名（必須） |
count
<?php
$user = new User();
$user->count();
// SELECT COUNT(*) as count FROM `easyswoole_user` LIMIT 1
$user->count('id', 'name');
// SELECT COUNT(id) as count FROM `easyswoole_user` GROUP BY name LIMIT 1
$user->queryLimit()->fields(['id', 'name']);
$user->count(null, 'name');
// SELECT COUNT(`id`) as id, COUNT(`name`) as name FROM `easyswoole_user` GROUP BY name LIMIT 1max
$user = new User();
$user->max('id');
// SELECT MAX(`id`) as id FROM `easyswoole_user` LIMIT 1
$user->max('id', 'name');
// SELECT MAX(`id`) as id FROM `easyswoole_user` GROUP BY name LIMIT 1
$user->max(['id', 'name'], 'name');
// SELECT MAX(`id`) as id , MAX(`name`) as name FROM `easyswoole_user` GROUP BY name LIMIT 1min
<?php
$user = new User();
$user->min('id');
// SELECT MIN(`id`) as id FROM `easyswoole_user` LIMIT 1
$user->min('id', 'name');
// SELECT MIN(`id`) as id FROM `easyswoole_user` GROUP BY name LIMIT 1
$user->min(['id', 'name'], 'name');
// SELECT MIN(`id`) as id , MIN(`name`) as name FROM `easyswoole_user` GROUP BY name LIMIT 1avg
<?php
$user = new User();
$user->avg('id');
// SELECT AVG(`id`) as id FROM `easyswoole_user` LIMIT 1
$user->avg('id', 'name');
// SELECT AVG(`id`) as id FROM `easyswoole_user` GROUP BY name LIMIT 1
$user->avg(['id', 'name'], 'name');
// SELECT AVG(`id`) as id , AVG(`name`) as name FROM `easyswoole_user` GROUP BY name LIMIT 1sum
<?php
$user = new User();
$user->sum('id');
// SELECT SUM(`id`) as id FROM `easyswoole_user` LIMIT 1
$user->sum('id', 'name');
// SELECT SUM(`id`) as id FROM `easyswoole_user` GROUP BY name LIMIT 1
$user->sum(['id', 'name'], 'name');
// SELECT SUM(`id`) as id , SUM(`name`) as name FROM `easyswoole_user` GROUP BY name LIMIT 1