write down,forget
标签 Tag : 函数

SQL函数大全及用法

<Category: SQL Server, 数据库> 5 条评论

–聚合函数
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

阅读这篇文章的其余部分 »

本文来自: SQL函数大全及用法