For Syllabus: Click to Download IP Class-12 Syllabus
Unit-2:
Video Lectures:
* Math functions: POWER (), ROUND (), MOD ().
Mod Function explanation
Step 1: Understanding the MOD Function
The MOD(x, y) function returns the remainder of x divided by y using the formula:
where FLOOR(x / y) gives the largest integer less than or equal to x / y.
Step 2: Divide 10.5 by 3
Step 3: Take the Floor of the Quotient
Step 4: Multiply the Floor Result by 3
Step 5: Subtract from 10.5
Final Output:
Query: SELECT MOD(10.5, 3);
Output: 1.5
-----------------------------
* 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.
* Working with two tables using equi-join
