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

Published: 10 January 2020
on channel: Becoming a Data Scientist

13,699

359

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:

Watch video How to ROUND in SQL (includes up CEILING and down FLOOR) online without registration, duration hours minute second in high quality. This video was added by user Becoming a Data Scientist 10 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 13,699 once and liked it 359 people.

797