SQL Tutorial for Data Analysis 19: Numeric Functions

Published: 06 September 2020
on channel: Ram Kedem

1,226

In this SQL tutorial we’re going to learn how to use some common scalar functions, that operate on numeric values.

Key concepts to remember -
The FLOOR() function rounds the number towards zero, downwards
The CEILING() function rounds the number, away from zero, always up.
The ROUND() function rounds the number to the nearest integer, so this function could round the number upwards or downward.

Course Examples -
https://ramkedem.com/en/sql-basics-ex...

ACDB Database -
https://ramkedem.com/en/acdb-sample-d...

Written SQL tutorials including exercises -
http://ramkedem.com/en/sql-server/

About Myself -
https://ramkedem.com/en/about/

My Linkedin Page -
/ ram-kedem-a5b4b33b

My Facebook Page -
/ ramkedemfeed

SQL Platform Differences (comparing MySQL & Oracle) -
Syntax covered in this lesson stays exactly the same on MySQL & Oracle

On this page of the site you can watch the video online SQL Tutorial for Data Analysis 19: Numeric Functions with a duration of hours minute second in good quality, which was uploaded by the user Ram Kedem 06 September 2020, share the link with friends and acquaintances, this video has already been watched 1,226 times on youtube and it was liked by 6 viewers. Enjoy your viewing!

181