Class name Subject Book title Chapter number Content Created at
Class XI Informatics Practices Informatics Practices 8 specified conditions. In the OFFICE database, more than one employee can have the same salary. To display distinct salaries of the employees workin...
Class XI Informatics Practices Informatics Practices 8 | 103 | Shabbir | 45000 | 566 | D01 | | 104 | Gurpreet | 19000 | 565 | D04 | | 105 | Joseph | 34000 | 875 | D03 | | 106 | Sanya | 48000 | 695 | D02...
Class XI Informatics Practices Informatics Practices 8 which the column value must fall into, to make the condition true. Example 8.7 The following query displays details of all the employees who are wo...
Class XI Informatics Practices Informatics Practices 8 ntroduction SotructureQueryLanguage(SQL) 163 Example 8.8 The following query displays details of all the N otes employees except those working in d...
Class XI Informatics Practices Informatics Practices 8 | D01 | | 106 | Sanya | 48000 | 695 | D02 | | 110 | Tanya | 50000 | 467 | D05 | | 102 | Kritika | 60000 | 123 | D01 | +-------+----------+--------+...
Class XI Informatics Practices Informatics Practices 8 all two queries and find out what will happen if those employees who have not been given a bonus. This we specify two columns implies that the bonu...
Class XI Informatics Practices Informatics Practices 8 used to represent zero, one, or multiple characters • _ (underscore)— used to represent a single character Example 8.13 The following query display...
Class XI Informatics Practices Informatics Practices 8 in name. statement with the process? List other real mysql> SELECT Ename life situations where you -> FROM EMPLOYEE can visualize an SQL -> WHERE E...
Class XI Informatics Practices Informatics Practices 8 Warnings: 0 We can then verify the updated data using the statement SELECT * FROM STUDENT . Caution : If we miss the where clauseUPDATEstatement th...
Class XI Informatics Practices Informatics Practices 8 101010101010 | | 6 | Manika P. | 2002-03-10 | 466444444666 | +------------+--------------+--------------+--------------+ 5 rows in set (0.00 sec) C...
Class XI Informatics Practices Informatics Practices 8 that match any value in the given list of values. • NULL values can be tested using IS NULL and IS NOT NULL. • ORDER BY clause is used to display t...
Class XI Informatics Practices Informatics Practices 8 i) 1 row ii) All the rows where student ID is equal to 109 iii) No row will be deleted iv) 2 rows 3. Fill in the blanks: a) declares that an index ...
Class XI Informatics Practices Informatics Practices 8 of class XI and Class XII. Students of each class are asked to join any one of the four teams — Team Titan, Team Rockers, Team Magnet and Team Hurr...
Class X Science Science 11 the same material and of the same length is used in the circuit. A change in ammeter reading is observed when a wire of different material of the s...
Class VI Mathematics Ganita Prakash 3 Closest to 50000 51,111 51,379 Q.6. Write one 5-digit number and two 3-digit numbers such that their sum is 18,670. Ans. 18000 + 300 + 370 = 18670....
Class XI Informatics Practices Informatics Practices 8 all those matches where both the teams have scored > 70. b) Retrieve the MatchID of all those matches where FirstTeam has scored < 70 but SecondTea...
Class XI Informatics Practices Informatics Practices 8 Find names of employees working in a department, say, ‘SALES’ and having exactly two dependents. 10. A shop called Wonderful Garments that sells sc...
Class XI Informatics Practices Informatics Practices 8 2026-27
Class XI Knowledge Traditions Practi... Knowledge Traditions Practi... 1 Language and Literature of India Language is one of the most beautiful and intriguing phenomenon in the world. It is closest to all living beings, ...
Class X Science Science 11 4 Ω, 8 Ω, 12 Ω, 24 Ω? 11.7 HEA TING EFFECT OF ELECTRIC CURRENT We know that a battery or a cell is a source of electrical energy. The chemicalreact...
Class XI Knowledge Traditions Practi... Knowledge Traditions Practi... 1 is the primary means by which culture is expressed, and maintained too. The overwhelming amount of knowledge created and owned by human beings is p...
Class XI Knowledge Traditions Practi... Knowledge Traditions Practi... 1 of learning language that these values embedded in culture are absorbed. Language becomes an intrinsic aspect of our human inheritance. Journey of ...
Class XI Knowledge Traditions Practi... Knowledge Traditions Practi... 1 for man. The earliest masters in linguistics were ancient Indian grammarians. The works of Panini and other Sanskrit grammarians had profoundly inf...
Class X Science Science 11 energy expended by the source? This energy gets dissipated in the resistor as heat. Thus for a steady current I, the amount of heat H produced in t...
Class XI Knowledge Traditions Practi... Knowledge Traditions Practi... 1 is mirrored in her literatures, both oral and written. Sanskrit belongs to Indo-European group of languages. Sanskrit was gradually standardised an...