Перейти к содержимому

How to ROUND in SQL (includes up CEILING and down FLOOR)

Becoming a Data Scientist

0:00 / 0:00

How to ROUND in SQL (includes up CEILING and down FLOOR)

18 295 просмотров · 6 л. назад
Becoming a Data Scientist
26,9 тыс. подписчиков
18 295 просмотров · 6 л. назад
A quick tutorial on how to ROUND to the nearest integer or up (CEILING) to the next integer or down (FLOOR) to the base integer! QUERIES: 1) Round to nearest integer: SELECT ROUND(num) FROM table 2) Round up: SELECT CEILING(num) FROM table 3) Round down: SELECT FLOOR(num) FROM table Get the Northwind Database:    • How to Load a Sample PostgreSQL Database i...   Support the Channel: 1) Subscribe: 2) DataCamp: 3) Udacity: