## 聚合查詢
>[info]統計數據
~~~
db.name('user').count()
~~~
~~~
db.name('user').count('id')
~~~
>[info]獲取最大值
~~~
db.name('user').max('balance')
~~~
>[info]獲取最小值
~~~
db.name('user').min('balance')
~~~
>[info]獲取平均值
~~~
db.name('user').avg('balance')
~~~
>[info]獲取總和
~~~
db.name('user').sum('balance')
~~~
- 連接數據庫
- 鏈式操作方法
- distinct
- field
- withoutField
- name
- alias
- force
- join
- leftJoin
- rightJoin
- union
- unionAll
- where
- whereOr
- whereTime
- whereBetweenTime
- whereNotBetweenTime
- whereBetweenTimeField
- whereNotBetweenTimeField
- whereYear
- whereMonth
- whereWeek
- whereDay
- group
- having
- order
- orderRand
- limit
- page
- lock
- comment
- ignore
- inc
- dec
- fetchSql
- 查詢數據
- 聚合查詢
- 新增數據
- 更新數據
- 刪除數據
- 原生操作