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

Описание к видео How to ROUND in SQL (includes up CEILING and down FLOOR)

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 Datab...  

Support the Channel:
1) Subscribe:
2) DataCamp:
3) Udacity:

Комментарии

Информация по комментариям в разработке