//合并字符串
select Lastname+','+FirstName
AS Employees
FROM Employees
ORDER BY LastName,FirstName ASC
//对数字列进行运算
select ROUND(UnitPrice*8,2)//数字列的乘法运算并取四舍五入的结果
AS DiscountPrice
From Products
where ProdutID=10032
//合并字符串
select Lastname+','+FirstName
AS Employees
FROM Employees
ORDER BY LastName,FirstName ASC
//对数字列进行运算
select ROUND(UnitPrice*8,2)//数字列的乘法运算并取四舍五入的结果
AS DiscountPrice
From Products
where ProdutID=10032