sql-ultimate-course/scripts/08_Number_Functions.sql at main · Vevek-github/sql-ultimate-course · GitHub

34 lines (29 loc) · 1.28 KB

/* ==============================================================================

SQL Number Functions Guide

-------------------------------------------------------------------------------

This document provides an overview of SQL number functions, which allow

performing mathematical operations and formatting numerical values.

Table of Contents:

1. Rounding Functions

- ROUND

2. Absolute Value Function

- ABS

=================================================================================

/* ==============================================================================

ROUND() - Rounding Numbers

=============================================================================== */

-- Demonstrate rounding a number to different decimal places

SELECT

3.516 AS original_number,

ROUND(3.516, 2) AS round_2,

ROUND(3.516, 1) AS round_1,

ROUND(3.516, 0) AS round_0

/* ==============================================================================

ABS() - Absolute Value

=============================================================================== */

-- Demonstrate absolute value function

SELECT

-10 AS original_number,

ABS(-10) AS absolute_value_negative,

ABS(10) AS absolute_value_positive

Expand file tree