SQL Functions🎬

📝View PDF Notes

SQL Funtions:
Math functions: POWER(), ROUND(), MOD()
Text functions: UCASE()/UPPER(),LCASE()/LOWER(),MID()/SUBSTRING()/ SUBSTR(), LENGTH(), LEFT(), RIGHT(), INSTR(),LTRIM(), RTRIM(), TRIM()
Date Functions: NOW(), DATE(), MONTH(), MONTHNAME(), YEAR(), DAY(), DAYNAME()
Aggregate Functions: MAX(), MIN(), AVG(), SUM(), COUNT(); using COUNT(*)
Querying and manipulating data using Group by, Having, Order by.