sql-learning-notes/11_SQL_Number-functions.sql at main · Nicooo00/sql-learning-notes · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
/*-------------NUMBER FUNCTIONS-------------*/


----------------ROUND----------------
/*
Zaokragla liczby. Zaokragla od 5 w gore, ponizej w dol.
*/

SELECT
	3.516,
	ROUND(3.516,2) as zaokraglenie_do_miejsc,
	ROUND(3.516,1) as zaokraglenie_do_jednego,
	ROUND(3.516,3) as zaokraglenie_do_trzech;

-----------------ABS-----------------
/*
Zwraca wartosc bezwgledna liczby.
*/

SELECT
	-10,
	ABS(-10) as bezwgledna