Home >Database >Mysql Tutorial >sql server函数大全(1/16)

sql server函数大全(1/16)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:47:351499browse

本款收藏了大量的sql server函数集中到一篇文章,从简单的sql查询函数,字符处理函数,存储过程函数,统计求各,字符截取函数,日期函数等。

本款收藏了大量的sql server函数集中到一篇文章,从简单的sql查询函数,字符处理函数,函数,统计求各,字符截取函数等。

sql server函数大全
--聚合函数
use pubs
go
select avg(distinct price)  --算平均数
from titles
where type='business'
go
use pubs
go
select max(ytd_sales)  --最大数
from titles
go

use pubs
go
select min(ytd_sales) --最小数
from titles
go

use pubs
go
select type,sum(price),sum(advance)  --求和
from titles
group by type
order by type
go

use pubs
go
select count(distinct city)  --求个数
from authors
go

use pubs
go
select stdev(royalty) --返回给定表达式中所有值的统计标准偏差
from titles
go

use pubs
go
select stdevp(royalty) --返回表达式中所有制的填充统计标准偏差
from titles
go

use pubs
go
select var(royalty) --返回所有值的统计方差
from titles
go 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn