SQL Server Functions (1/16)

This section adds a large number of sqlserver functions to an article, from simple SQL query functions, character processing functions, stored procedure functions, statistics, and character truncation functions, date functions.

This section adds a large number of SQL server functions to an article, from simple SQL query functions, character processing functions, stored procedure functions, statistical calculations, and character truncation functions, date functions.

This section adds a large number of SQL server functions to an article, from simple SQL query functions, character processing functions, functions, statistics, and character truncation functions.

SQL server Functions
-- Aggregate functions
Use pubs
Go
Select avg (distinct price) -- calculate the 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) -- calculate the number
From authors
Go

Use pubs
Go
Select stdev (royalty) -- returns the statistical standard deviation of all values in a given expression
From titles
Go

Use pubs
Go
Select stdevp (royalty) -- return the standard deviation of filling Statistics for ownership in the expression
From titles
Go

Use pubs
Go
Select var (royalty) -- returns the statistical variance of all values
From titles
Go