Numeric functions in SQL | Oracle

Functions can be used anywhere in SQL, like AVG, COUNT, SUM, MIN, DATE and so on with select statements. Functions compile every time. Functions must return a value or result. Functions only work with input parameters.

1. Return the absolute value of a number
The ABS() function returns the absolute (positive) value of a number.
Syntax-
ABS(number)
ABS() FUNCTION

2. ABS() function

3. The My SQL ACOS function returns the arc cosine of a number.

The function returns NULL when the value of the number is not between
the range of -1 and 1.
Syntax-
ACOS( number )
ACOS() function

4. ACOS() function
.

5. ACOS() function

6. ASIN() Function
Returns the arc sine of a number

The specified number must be between -1 to 1, otherwise this function
returns null
Syntax-
ASIN(number)

7. ASIN() Function

8. ASIN() Function

9. ATAN() Function
Return the arc tangent of a number:
The ATAN2() function returns the arc tangent of one or two numbers.

Syntax-
ATAN(number)
or
ATAN2(a,b)

10. ATAN() Function
.

11. ATAN2() Function
.

12. AVG() Function
The AVG() function returns the average value of an expression.
NULL values are ignored.

Syntax-
AVG(expression)

13. AVG() Function

14. CEIL() Function
Returns the smallest integer value that is >= to a number.
This function is equal to the CEILING() function.

Syntax-
CEIL(number)

15. CEIL() Function

16. COS() Function
Return the cosine of a number

Syntax-
COS(number)

17. COS() Function

18. COS() Function

19. COT() Function
Return the cotangent of a number

Syntax-
COT(number)

20. COT() Function

21. COT() Function

22. COUNT() Function
The COUNT() function returns the number of records returned by a select
query.
NULL values are not counted.
 
Syntax-
COUNT(expression)

23. COUNT() Function

24. DEGREES() Function
The DEGREES() function converts a value in radians to degrees.
 
Syntax-
DEGREES(number)

25. DEGREES() Function

26. DEGREES() Function

27. DIV() Function
The DIV function is used for integer division (x is divided by y).
 An integer value is returned.
 
Syntax-
x DIV y

28. DIV() Function

29. EXP() Function
The EXP() function returns e raised to the power of the specified number.
The constant e (2.718281...), is the base of natural logarithms.
Syntax-
EXP(number)

30. EXP() Function

31. FLOOR() Function
The FLOOR() function returns the largest integer value that is smaller than 
or equal to a number.
Syntax-
FLOOR(number)

32. FLOOR() Function

33. GREATEST() Function
The GREATEST() function returns the greatest value of the list of 
Arguments.
Syntax-
GREATEST(arg1, arg2, arg3, ...)

34. GREATEST() Function

35. LEAST() Function
The LEAST() function returns the smallest value of the list of arguments.
Syntax-
LEAST(arg1, arg2, arg3, ...)

36. LEAST() Function

37. LN() Function
The LN() function returns the natural logarithm of a number.
Syntax-
LN(number)

38. LN() Function

39. LOG() Function
The LOG() function returns the natural logarithm of a specified number, or 
the logarithm of the number to the specified base.
Syntax-
LOG(number)
           or
        LOG(base, number)

40. LOG() Function

41. LOG() Function

42. LOG10() Function
The LOG10() function returns the natural logarithm of a number to base-10.
Syntax-
LOG10(number)

43. LOG10() Function

44. LOG10() Function

45. LOG2() Function
The LOG2() function returns the natural logarithm of a number to base-2.
Syntax-
LOG2(number)

46. LOG2() Function

47. MAX() Function
The MAX() function returns the maximum value in a set of values.
Syntax-
MAX(expression)

48. MAX() Function

49. MIN() Function
The MIN() function returns the minimum value in a set of values.
Syntax-
MIN(expression)

50. MIN() Function

51. MOD() Function
The MOD() function returns the remainder of a number divided by another 
number.
Syntax-

MOD(x, y)
Or
x MOD y

52. MOD() Function

53. MOD() Function

54. PI() Function
The PI() function returns the value of PI.
Syntax-
PI()

55. PI() Function

56. POW() Function
The POW() function returns the value of a number raised to the power of 
another number.
Syntax-
POW(x, y)

57. POW() Function

58. SIGN() function
The SIGN() function returns the sign of a number.
This function will return one of the following:
If number > 0, it returns 1
If number = 0, it returns 0
If number < 0, it returns -1
Syntax-  SIGN(number) 

59. SIGN() function
The ASCII() function returns the ASCII value for the specific character.

60. TRUNCATE() function
The TRUNCATE() function truncates a number to the specified number of 
decimal places.
Syntax-  TRUNCATE(number, decimals)

61. TRUNCATE() function

62. ROUND() Function
The ROUND() function rounds a number to a specified number of decimal
places.
Syntax-


ROUND (Number, decimals)

63. ROUND() Function

64. RAND() Function
The RAND() function returns a random number between 0 (inclusive) and 1
(exclusive).
Seed - Optional. If seed is specified, it returns a repeatable sequence of
random numbers. If no seed is specified, it returns a completely random
number
Syntax-

RAND(seed)

65. RAND() Function

66. TAN() Function
The TAN() function returns the tangent of a number.
Syntax-
TAN(number)

67. TAN() Function
The ASCII() function returns the ASCII value for the specific character.

68. SIN() function
Syntax-
SIN(number)
The SIN() function returns the sine of a number.

69. SIN() function
.

70. SQRT() Function
The SQRT() function returns the square root of a number.
Syntax-
SQRT(number)

71. SQRT() Function

72. SUM() Function
The SUM() function calculates the sum of a set of values.
Syntax-

SUM(expression)

73. SUM() Function
The ASCII() function returns the ASCII value for the specific character.

74. RADIANS() function
Syntax- RADIANS(number)
The RADIANS() function converts a degree value into radians.

75. RADIANS() function
The ASCII() function returns the ASCII value for the specific character.

76. POWER() Function
The POWER() function returns the value of a number raised to the power of
another number.
Syntax- POWER (x,y)

77. POWER() function