More math


SQL provides the ability to perform many more mathematical operations which are beyond the scope of this introductory course, including:

  • LOG() - Return the natural logarithm of a number
  • ABS() - Return the absolute value of a number
  • SQRT() - Return the square root of a number
  • POWER(number, power_to_raise to) - Take a number and return the value of that number, raised to a specified power
  • Trigonometric functions like SIN() and COS()