select ad, name, CONCAT(MAX(CESHIZHI),'/',CESHISHIJIAN) AS MAX_VALUE ,CONCAT(MIX(CESHIZHI),'/',CESHISHIJIAN) AS MIX_VALUE,AVG(CESHIZHI) AS AVG_VALUE from dianyuanping where CONVERT(varchar,CESHISHIJIAN,108)=CONVERT(varchar,GetDate(),108) GROUP BY name
用MYSQL CC 测试有错误,不知道原因!