Shulou(Shulou.com)06/01 Report--

Aggregate functions: MAX (maximum), MIN (minimum), AVG (average), SUM (and), COUNT (quantity)

ABS (): find the absolute value.

CEILING (): rounds to the largest integer. 3.33 will be rounded to 4, 2.89 will be rounded to 3,-3.61 will be rounded to-3.

FLOOR (): rounds to the smallest integer. 3.33 will be rounded to 3, 2.89 will be rounded to 2,-3.61 will be rounded to-4.

ROUND (): rounded. Round to the number closest to my radius.

Round → Radius. Round (3.1425pc.2).

SqlServer2012 iif (expression 1, expression 2, expression 3) returns when expression 1 is True, expression 2 can be nested

ISNULL (expression,value) returns expression if expression is not empty, value otherwise

SELECT ISNULL (FName,' Anonymous') as name FROM

T_Employee

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.