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:
