Chapter Content type Value Position Created at
Chapter 1 - Informatics Pra... text 4 nformaticPractices 1.2 F unctions in SQL We know that a... 8 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 9 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 5 (A) Numeric Functions Three co... 10 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 11 Delete Content
Chapter 1 - Informatics Pra... text 6 NFORMATICSPRACTICES mysql> ALTER TABLE INVENTORY ADD Fi... 12 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 13 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 7 Example 1.2 a) Let us now add ... 14 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 15 Delete Content
Chapter 1 - Informatics Pra... text 8 InformaticPractices or vice-versa), extract a substring... 16 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 17 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 9 RTRIM(string) Returns the give... 18 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 19 Delete Content
Chapter 1 - Informatics Pra... text 10 NFORMATICPRACTICES c) Let us assume that four digit ar... 20 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 21 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 11 Table 1.7 Date Functions Func... 22 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 23 Delete Content
Chapter 1 - Informatics Pra... text InformatiPractices 12 mysql> SELECT DAYNAME(DOJ), DAY(DOJ... 24 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 25 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 13 SUM(column) Returns the sum o... 26 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 27 Delete Content
Chapter 1 - Informatics Pra... text 14 nformaticPractices mysql> SELECT COUNT(DISTINCT Model)... 28 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 29 Delete Content
Chapter 1 - Informatics Pra... text Q uerying aSQL Functions 15 in these columns to find the ... 30 Delete Content
Chapter 1 - Informatics Pra... image /default_org/ncert_images/class-xii/i... 31 Delete Content
Chapter 1 - Informatics Pra... text 16 InformaticPractices N otes BY Paymentmode; +----------... 32 Delete Content