复制use pubs go select avg(distinct price) --算平均数 from titles where type=business use pubs go select max(ytd_sales) --最大数 from titles use pubs go select min(ytd_sales) --最小数 from titles use pubs go select type,据库锦sum(price),sum(advance) --求和 from titles group by type order by type use pubs go select count(distinct city) --求个数 from authors use pubs go select stdev(royalty) --返回给定表达式中所有值的统计标准偏差 from titles use pubs go select stdevp(royalty) --返回表达式中所有制的填充统计标准偏差 from titles use pubs go select var(royalty) --返回所有值的源码下载统计方差 from titles use pubs go select varp(royalty) --返回所有值的填充的香港云服务器统计方差 from titles 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46. |
喜欢
讨厌