MOD POWER SQRT Functions in SQL Lesson 61 DBMS Learning Monkey

>> DOWNLOAD LINK 🎞️ #1 <<

>> DOWNLOAD LINK 🎞️ #2 <<

>> COPY / PASTE LINK PLEASE 🎵 MP3 <<

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=OGWTPKrpJ88

MOD POWER SQRT functions in SQL • In this class, we will understand MOD POWER SQRT functions in SQL. • We have already understood the concepts of ABS CEIL and FLOOR. • MOD POWER SQRT functions in SQL • The other kinds of mathematical functions that are possible are MOD POWER SQRT functions in SQL. • To understand these functions consider the table as shown below. • MOD • MOD is used for Modulus division to produce the remainder of the division. • The syntax for MOD is shown below. • MOD(Value, Divisor) • The use of MOD and its output is as shown below. • POWER • POWER is used to value the given positive exponent. • The syntax for POWER is shown below. • POWER(Value, Exponent) • The use of POWER and its output is as shown below. • SQRT • SQRT is used to find the Square Root of the given number. • The syntax for SQRT is shown below. • SQRT(value) • The SQRT should not be used with negative numbers. • If we use SQRT with the negative number the SQL will produce an error as shown below. • To avoid that error we can use the ABS function within the SQRT function as shown below. • • #learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements • • Link for playlists: •    / @learningmonkey   • • Link for our website: https://learningmonkey.in • Follow us on Facebook @   / learningmonkey   • Follow us on Instagram @   / learningmonkey1   • Follow us on Twitter @   / _learningmonkey   • Mail us @ [email protected]

#############################