• 查询聚合查询.aggregate
    • 记录数量 count
    • 平均值 avg
    • 最大值 max
    • 最小值 min
    • 合计 sum

    查询聚合查询.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');