# Learn to Code SQL Example – SQL | Numeric Functions # SQL | Numeric Functions

Numeric Functions are used to perform operations on numbers and return numbers.
Following are the numeric functions defined in SQL:

1. ABS(): It returns the absolute value of a number.
`Syntax: SELECT ABS(-243.5);`

Output: 243.5

```SQL> SELECT ABS(-10);
+--------------------------------------+
| ABS(10)
+--------------------------------------+
| 10
+--------------------------------------+
```
2. ACOS(): It returns the cosine of a number.
`Syntax:  SELECT ACOS(0.25);`

Output: 1.318116071652818

3. ASIN(): It returns the arc sine of a number.
`Syntax: SELECT ASIN(0.25);`

Output: 0.25268025514207865

4. ATAN(): It returns the arc tangent of a number.
`Syntax: SELECT ATAN(2.5);`

Output: 1.1902899496825317

5. CEIL(): It returns the smallest integer value that is greater than or equal to a number.
`Syntax: SELECT CEIL(25.75);`

Output: 26

6. CEILING(): It returns the smallest integer value that is greater than or equal to a number.
`Syntax: SELECT CEILING(25.75);`

Output: 26

7. COS(): It returns the cosine of a number.
`Syntax: SELECT COS(30);`

Output: 0.15425144988758405

8. COT(): It returns the cotangent of a number.
`Syntax: SELECT COT(6);`

Output: -3.436353004180128

9. DEGREES(): It converts a radian value into degrees.
`Syntax: SELECT DEGREES(1.5);`

Output: 85.94366926962348

```SQL>SELECT DEGREES(PI());
+------------------------------------------+
| DEGREES(PI())
+------------------------------------------+
| 180.000000
+------------------------------------------+```
10. DIV(): It is used for integer division.
`Syntax: SELECT 10 DIV 5;`

Output: 2

11. EXP(): It returns e raised to the power of number.
`Syntax: SELECT EXP(1);`

Output: 2.718281828459045

12. FLOOR(): It returns the largest integer value that is less than or equal to a number.
`Syntax: SELECT FLOOR(25.75);`

Output: 25

13. GREATEST(): It returns the greatest value in a list of expressions.
`Syntax: SELECT GREATEST(30, 2, 36, 81, 125);`

Output: 125

14. LEAST(): It returns the smallest value in a list of expressions.
`Syntax: SELECT LEAST(30, 2, 36, 81, 125);`

Output: 2

15. LN(): It returns the natural logarithm of a number.
`Syntax: SELECT LN(2);`

Output: 0.6931471805599453

16. LOG10(): It returns the base-10 logarithm of a number.
`Syntax: SELECT LOG(2);`

Output: 0.6931471805599453

17. LOG2(): It returns the base-2 logarithm of a number.
`Syntax: SELECT LOG2(6);`

Output: 2.584962500721156

18. MOD(): It returns the remainder of n divided by m.
`Syntax: SELECT MOD(18, 4);`

Output: 2

19. PI(): It returns the value of PI displayed with 6 decimal places.
`Syntax: SELECT PI();`

Output: 3.141593

20. POW(): It returns m raised to the nth power.
`Syntax: SELECT POW(4, 2);`

Output: 16

`Syntax: SELECT RADIANS(180);`

Output: 3.141592653589793

22. RAND(): It returns a random number.
`Syntax: SELECT RAND();`

Output: 0.33623238684258644

23. ROUND(): It returns a number rounded to a certain number of decimal places.
`Syntax: SELECT ROUND(5.553);`

Output: 6

24. SIGN(): It returns a value indicating the sign of a number.
`Syntax: SELECT SIGN(255.5);`

Output: 1

25. SIN(): It returns the sine of a number.
`Syntax: SELECT SIN(2);`

Output: 0.9092974268256817

26. SQRT(): It returns the square root of a number.
`Syntax: SELECT SQRT(25);`

Output: 5

27. TAN(): It returns the tangent of a number.
`Syntax: SELECT TAN(1.75);`

Output: -5.52037992250933

28. ATAN2(): It returns the arctangent of the x and y coordinates, as an angle and expressed in radians.
`Syntax: SELECT ATAN2(7);`

Output: 1.42889927219073

29. TRUNCATE(): This doesn’t work for SQL Server. It returns 7.53635 truncated to 2 places right of the decimal point.
`Syntax: SELECT TRUNCATE(7.53635, 2);`

Output: 7.53

Excel formula for Beginners – How to Count unique numeric values in a range in Excel

# Personal Career & Learning Guide for Data Analyst, Data Engineer and Data Scientist

## Applied Machine Learning & Data Science Projects and Coding Recipes for Beginners

A list of FREE programming examples together with eTutorials & eBooks @ SETScholars

# Projects and Coding Recipes, eTutorials and eBooks: The best All-in-One resources for Data Analyst, Data Scientist, Machine Learning Engineer and Software Developer

Topics included: Classification, Clustering, Regression, Forecasting, Algorithms, Data Structures, Data Analytics & Data Science, Deep Learning, Machine Learning, Programming Languages and Software Tools & Packages.
(Discount is valid for limited time only) `Disclaimer: The information and code presented within this recipe/tutorial is only for educational and coaching purposes for beginners and developers. Anyone can practice and apply the recipe/tutorial presented here, but the reader is taking full responsibility for his/her actions. The author (content curator) of this recipe (code / program) has made every effort to ensure the accuracy of the information was correct at time of publication. The author (content curator) does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause. The information presented here could also be found in public knowledge domains.`

# Learn by Coding: v-Tutorials on Applied Machine Learning and Data Science for Beginners

Please do not waste your valuable time by watching videos, rather use end-to-end (Python and R) recipes from Professional Data Scientists to practice coding, and land the most demandable jobs in the fields of Predictive analytics & AI (Machine Learning and Data Science).

The objective is to guide the developers & analysts to “Learn how to Code” for Applied AI using end-to-end coding solutions, and unlock the world of opportunities!