UNIT-2-Database Query using SQL

For Syllabus:  Click to Download IP Class-12 Syllabus

Unit-2:

Video Lectures:

Click Here - Revision of database concepts and SQL commands covered in class XI 

* 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:

$$MOD(x,y)=x-(y\times \text{FLOOR}(x\mathrm{/}y))$$

where FLOOR(x / y) gives the largest integer less than or equal to x / y.

---

Step 2: Divide 10.5 by 3

$$10.5÷3=3.5$$

---

Step 3: Take the Floor of the Quotient

$$\text{FLOOR}(3.5)=3$$

---

Step 4: Multiply the Floor Result by 3

$$3\times 3=9$$

---

Step 5: Subtract from 10.5

$$10.5-9=1.5$$

---

Final Output:

$$MOD(10.5,3)=1.5$$

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 ()

Notes: Math, Text and Date Functions :  Click Here to View in pdf

* Aggregate Functions: MAX (), MIN (), AVG (), SUM (), COUNT (); using COUNT (*)

Notes: Aggregate Functions : Click Here to View 

* Querying and manipulating data using Group by, Having, Order by.

Notes: Order By, Group By and Having:  Click Here to View

* Working with two tables using equi-join

Notes: Equi-Join: Click Here to View     [ Additional concepts with example ]