WebClass 12 IP Term-2 Tutorial Notes Unit-2 SQL Aggregate Functions MySQL Date Functions Part-3. techtipnow. 16.2K subscribers. Subscribe. 11K views 1 year ago IP Class 12 Tutorial 2024-23. # ... WebInformatics Practices Class 12 Important Questions Chapter 11 SQL Functions and Table Joins 2 Marks Questions Question 1. Write the output of the following SQL queries: (i) SELECT RIGHT (‘software’, 2); (ii) SELECT INSTR (‘twelve’, lV); (iii) SELECT DAYOFMONTH (‘2014-03-01’); (iv) SELECT (76.987,2); (All India 2014C) Answer: (i) re …
CBSE Class 12 Informatics Practices - Unacademy
WebIP Class 12 Notes Class 12 Informatics Practices Notes Find out well organized and structured IP Class 12 Notes prepared as per CBSE Syllabus covering chapter wise all … WebOct 19, 2024 · The next section for MySQL Functions class 12 IP contains query based questions. Write queries do display: To join product and company and display in tabular form like – iPad manufatured by Apple Convert all product named into capital Count total number of letters for all company. gears tv affiliate programs
Term 2 Notes Informatics Practices Class 12 TutorialAICSIP
WebClass 12 IP Database Query Using SQL Notes IP Class 12 SQL Notes Leave a Comment / IP Class 12 Tutorial , SQL Tutorials / By Sanjay Kumar Get well organized Unit-2 Class 12 IP Database Query Using SQL Notes prepared as per CBSE Syllabus cover all topics to score high marks. WebJan 18, 2024 · Join CBSE Class 12 Informatics Practices course on Unacademy conducted by Top Educators. Learners can also get access to curated chemistry course and previous years & mock questions. Prepare for CBSE Class 12 Informatics Practices with Top Educators on Unacademy Class 12 IP Database Query Using SQL Important NCERT Notes. Chapter 1 Informatics Practices. POWER (), ROUND (), MOD (). UCASE ()/UPPER (), LCASE ()/LOWER (), MID ()/SUBSTRING ()/SUBSTR (), LENGTH (), LEFT (), RIGHT (), INSTR (), LTRIM (), RTRIM (), TRIM (). NOW (), DATE (), MONTH (), … See more Those functions which are applied on a single value and return a single value are called Single Row Functions. There are three categories of single row functions in SQL 1. Numeric … See more Q1. Write the output of the following statements : 1. Select round(1245.231, 1); 2. Select round(7564.254, 2); 3. Select round(8925.86,1); 4. Select round(369.825,0); 5. Select round(569.235,-1); 6. … See more Q1. Write a query to join two tables Student and Book on the basis of field Admission Number. Ans. Select * from Student, Book where Student.Admno = Book.Admno; OR Select * from Student Join Book on … See more Aggregate functions are also called multiple row functions. These functions work on a set of records as a whole, and return a single value … See more gearstv.com