Math functions of SQL | String functions of SQL | date functions of SQL | SQL functions class 12
In this video mathematical, text and date functions have been explained using practical examples in MYSQL.
Math functions:
i. POWER () ii. ROUND () iii. MOD ().
Text functions:
i. UCASE ()/UPPER () ii. LCASE ()/LOWER ()
iii. MID ()/SUBSTRING ()/SUBSTR () iv. LENGTH ()
v. LEFT () vi. RIGHT () vii. INSTR ()
viii. LTRIM () ix. RTRIM () x.TRIM ().
Date Functions:
i. NOW () ii. DATE () iii. MONTH ()
iv. MONTHNAME () v. YEAR () vi. DAY () vii. DAYNAME ().
Click https://ladderpython.com/lesson/sql-c... for more details
Click • Downloading Python | Installing Pytho... for Python tutorial
click https://ladderpython.com/course/xii-c... for class 12 computer science notes.
Click https://ladderpython.com/course/cbse-... for class 11 computer science notes
Watch video Math functions of SQL | String functions of SQL | date functions of SQL | SQL functions class 12 online without registration, duration hours minute second in high quality. This video was added by user Lovejot Bhardwaj 23 April 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,72 once and liked it 6 people.