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: