摘要： --聚合函数use pubsgoselect avg(distinct搜索 price) --算平均数from titleswhere type='business'go use pubsgoselect max(ytd_sales) --最大数from titlesgo use pubsgoselect min(ytd_sales) --最小数from titlesgo use pubsgoselect type,sum(price),sum(advance) --求和from titlesgroup by typeorder by typego use pubsgo sel 阅读全文