This section collects a large number of SQL Server functions to focus on an article, from simple SQL query functions, character processing functions, stored procedure functions, statistics, character interception functions.
SQL Server function Encyclopedia
--Aggregate functions
Use pubs
Go
Select AVG (DISTINCT price)--average
From titles
where type= ' business '
Go
Use pubs
Go
Select Max (ytd_sales)-Maximum number
From titles
Go
Use pubs
Go
Select min (ytd_sales)--Minimum number
From titles
Go
Use pubs
Go
Select Type,sum (Price), sum (advance)--sum
From titles
Group By Type
ORDER BY Type
Go
Use pubs
Go
Select COUNT (Distinct city)--Find the number
From authors
Go
Use pubs
Go
Select Stdev (Royalty)--Returns the statistical standard deviation of all values in the given expression
From titles
Go
Use pubs
Go
Select STDEVP (Royalty)--Returns the fill statistic standard deviation of the ownership in an expression
From titles
Go
Use pubs
Go
Select VAR (royalty)--Returns the statistical variance of all values
From titles
Go
home 1 2 3 4 5 6 7 8 9 A
last