sql server 2000 函数大全
--聚合函数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
转载
2011-03-20 23:18:00 ·
501 阅读 ·
0 评论