sql AVG()实例:
从access表中获取count子弹=段列的平均值;
select AVG(count) AS c from access;
查询高于site_id和count字段的平均值;
select site_id ,count from asscess
where count>(select AVG(count) from asscess);
sql max() 实例:
查询webtables表中的alexa字段最大值;
select max(alexa) as al from webtables;
sql sum() 实例:
下面的 SQL 语句查找 "access_log" 表的 "count" 字段的总数
SELECT SUM(count) AS nums FROM access_log;
sql group by 语句实例:
group by语句用于结合聚合函数,根据一个或多个列对结果集进行分组
select site_id,SUM(access_log.count) as nums
frim access_log GrOUP BY site_id;
sql group BY 多表连接
select webtabe.name, count(acess_log.aid) as num
from access_log
left join webstable
on access_log= webstable.id
GROUP BY webtables.name;