Скачать или смотреть SQL Server Numeric Functions (Session 13)

SQL Server Numeric Functions
 AVG
 MIN
 MAX
 CEILING
 FLOOR
 COUNT
 SUM
 RAND
 ROUND
------------------------------------------------------------------------------------------------------------
CREATE TABLE [dbo].[Sales](
[Country] [varchar](50) NULL,
[Region] [varchar](50) NULL,
[salary] [int] NULL,
[year] [varchar](100) NULL,
[id] [int] NULL
) ON [PRIMARY]
GO

---------------------------------------------------------------------------------------------------------------
select round(23.377,1)
insert into sales values('India', 'Bhopal', 1000, 2008,1)
insert into sales values('America', 'Washington', 2000, 2009,2)
---------------------------------------------------------------------------------------------------------------

select * from sales
select avg(id) from sales
select min(salary) from sales
select max(salary) from sales
select ceiling(id) from sales
select * from sales
select ceiling(23.18768757576)
select floor(23.1)
select count(region) from sales
select sum(region) from sales
select rand(2)
select round(23.377,1)