SQL SERVER -- Mathematical Functions-- Part-19
Mathematical functions are used to perform following operations. Like ABS,CEILING,FLOOR,ROUND,SQRT and so.. on.
ABS:- Used to ignore Negative Sign.This ABS() Function always returns the positive value even if the value is negative.
CEILING:- The Ceiling Function rounds up a number to the next whole number.
FLOOR:- The Floor function rounds up a number to before(Minimum) whole number
SQRT:- The SQRT Function returns SQRT of given expression.
SQUARE:- The SQUARE Function returns SQUARE of given expression.
ROUND:- The ROUND Function is used to ROUND the given the value based on the expression.
ABS:- Used to ignore Negative Sign.This ABS() Function always returns the positive value even if the value is negative.
CEILING:- The Ceiling Function rounds up a number to the next whole number.
FLOOR:- The Floor function rounds up a number to before(Minimum) whole number
SQRT:- The SQRT Function returns SQRT of given expression.
SQUARE:- The SQUARE Function returns SQUARE of given expression.
ROUND:- The ROUND Function is used to ROUND the given the value based on the expression.
No comments:
Post a Comment