查询聚合查询.aggregate

记录数量 count

  1. # 函数原型
  2. public function getCount($strField = '*', $sAlias = 'row_count', $bFlag = false);
  4. # SELECT COUNT(*) AS row_count FROM `test` LIMIT 1
  5. # int
  6. Db::table('test')->
  8. getCount()
  10. # SELECT COUNT(*) AS row_count FROM `test` LIMIT 1
  11. # int
  12. Db::table('test')->
  14. count()->
  16. get()->
  18. row_count;
  20. # SELECT COUNT(*) AS row_count2 FROM `test` LIMIT 1
  21. # int
  22. Db::table('test')->
  24. getCount('*', 'row_count2')

平均值 avg

  1. # 函数原型
  2. public function getAvg($strField, $sAlias = 'avg_value', $bFlag = false);
  4. # SELECT AVG(`test`.`num`) AS avg_value FROM `test` LIMIT 1
  5. # int
  6. Db::table('test')->
  8. getAvg('num');
  10. # SELECT AVG(`test`.`id`) AS avg_value FROM `test` LIMIT 1
  11. # int
  12. Db::table('test')->
  14. avg('id')->
  16. get()->
  18. avg_value;
  20. # SELECT AVG(`test`.`num`) AS avg_value2 FROM `test` LIMIT 1
  21. # int
  22. Db::table('test')->
  24. getAvg('num', 'avg_value2');

最大值 max

  1. # 函数原型
  2. public function getMax($strField, $sAlias = 'max_value', $bFlag = false);
  4. # SELECT MAX(`test`.`num`) AS max_value FROM `test` LIMIT 1
  5. # int
  6. Db::table('test')->
  8. getMax('num');
  10. # SELECT MAX(`test`.`id`) AS max_value FROM `test` LIMIT 1
  11. # int
  12. Db::table('test')->
  14. max('id')->
  16. get()->
  18. max_value;
  20. # SELECT MAX(`test`.`num`) AS max_value2 FROM `test` LIMIT 1
  21. # int
  22. Db::table('test')->
  24. getMax('num', 'max_value2');

最小值 min

  1. # 函数原型
  2. public function getMin($strField, $sAlias = 'min_value', $bFlag = false);
  4. # SELECT MIN(`test`.`num`) AS min_value FROM `test` LIMIT 1
  5. # int
  6. Db::table('test')->
  8. getMin('num');
  10. # SELECT MIN(`test`.`num`) AS min_value FROM `test` LIMIT 1
  11. # int
  12. Db::table('test')->
  14. min('num')->
  16. get()->
  18. min_value;
  20. # SELECT MIN(`test`.`num`) AS min_value2 FROM `test` LIMIT 1
  21. # int
  22. Db::table('test')->
  24. getMin('num', 'min_value2');

合计 sum

  1. # 函数原型
  2. public function getSum($strField, $sAlias = 'sum_value', $bFlag = false);
  4. # SELECT SUM(`test`.`num`) AS sum_value FROM `test` LIMIT 1
  5. # int
  6. Db::table('test')->
  8. getSum('num');
  10. # SELECT SUM(`test`.`num`) AS sum_value FROM `test` LIMIT 1
  11. # int
  12. Db::table('test')->
  14. sum('id')->
  16. get()->
  18. sum_value;
  20. # SELECT SUM(`test`.`num`) AS sum_value2 FROM `test` LIMIT 1
  21. # int
  22. Db::table('test')->
  24. getSum('num', 'sum_value2');