摘要： SQL函数大全--聚合函数usepubsgoselectavg(distinctprice)--算平均数fromtitleswheretype='business'gousepubsgoselectmax(ytd_sales)--最大数fromtitlesgousepubsgoselectmin(ytd_sales)--最小数fromtitlesgousepubsgoselecttype,sum(price),sum(advance)--求和fromtitlesgroupbytypeorderbytypegousepubsgoselectcount(distinctcity)--求个数from 阅读全文