| Class XII |
Computer Science |
Computer Science |
9 |
a string and so on. String functions and their usage are shown in Table 9.14. Table 9.14 String Functions Function Description Example with output ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
working of string functions. Using the table a) Display customer name in lower case and customer EMPLOYEE from email in upper case from table CUSTO... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
*, or /) d) Display emails after removing the domain name on date functions? extension “.com” from emails of the customers. mysql> SELECT TRIM(“.co... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the day, month number and year of joining of all employees. Activity 9.14 mysql> SELECT DAY(DOJ), MONTH(DOJ), YEAR(DOJ) FROM EMPLOYEE; a) Find sum ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
at a time.1. It operates on groups of rows. 2. It returns one result per row. 2. It returns one result for a group of rows. 3. It can be used in Se... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
total number of records from table INVENTORY having a model as VXI. mysql> SELECT COUNT(*) FROM INVENTORY WHERE Model=”VXI”; +----------+ | COUNT(*... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
Finance| E007 |659982.00 | 79198.84 | | I00005 | E001 | C0003 | 2018-12-20 | Credit Card | E002 |369310.00 | 44318.20 | | I00006 | S002 | C0002 | 2... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
than once. mysql> SELECT PaymentMode, Count(PaymentMode) FROM SALE GROUP BY Paymentmode HAVING COUNT(*)>1 ORDER BY Paymentmode; +--------------+---... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
relations DANCE and MUSIC. The output of UNION operation is shown in Table 9.20. StructuredQueryLanguage(SQL) 169 Reprint 2026-27 n oteS Table 9.20... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
| | 3 | Lavanya | 7A | | 5 | Abhay | 8A | +------+---------+-------+ 9.10.4 Cartesian Product (X) Cartesian product operation combines tuples from ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
2 | Mahira | 6A | 3 | Lavanya | 7A | | 3 | Mohit | 7B | 3 | Lavanya | 7A | | 4 | Sanjay | 7A | 3 | Lavanya | 7A | | 1 | Aastha | 7A | 4 | Sanjay | ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
and MUSIC mysql> SELECT * FROM DANCE, MUSIC; As we are using SELECT * in the query, the output will be the Table 9.23 having degree 6 and cardinali... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
common attribute between the two tables which can be used to fetch the common data from both tables. Hence, we need to define Ucode as foreign key ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the query is same as shown in Table 9.26. In this query we have used JOIN clause explicitly along with condition in From clause. Hence no condition... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
• In general, N-1 joins are needed to combine N tables on equality condition. • With JOIN clause, we may use any relational operators to combine tu... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
work on a single row of the table and return a single value. • Multiple Row functions work on a set of records as a whole and return a single value... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
- 30500 - a) Display all the information from the Movie table. b) List business done by the movies showing only MovieID, MovieName and Total_Earnin... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
Team Magnet) Row 3: (4, Team Hurricane) f) Show the contents of the table TEAM using a DML statement. g) Now create another table MATCH_DETAILS and... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the values for the handkerchief without entering its details in the UNIFORM relation is entered. Make a provision so that the data can be entered i... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
GROUP BY PName; 8. Using the CARSHOWROOM database given in the chapter, write the SQL queries for the following: a) Add a new column Discount in th... |
|
| Class XII |
Economics |
Introductory Macroeconomics |
1 |
Chapter 1 Introduction You must have already been introduced to a study of basic microeconomics. This chapter begins by giving you a simplified acc... |
|
| Class XII |
Economics |
Introductory Macroeconomics |
1 |
category of industrial goods also output of different kinds of goods tend to rise or fall simultaneously. Similarly, prices of different goods and ... |
|
| Class XII |
Economics |
Introductory Macroeconomics |
1 |
the movements of these variables for all the individual commodities are usually of the same kind as are seen for the aggregates for the economy as ... |
|
| Class XII |
Economics |
Introductory Macroeconomics |
1 |
this discussion here, and your earlier reading of microeconomics, you may have already begun to understand in what Reprint 2026-27 way macroeconomi... |
|
| Class XII |
Economics |
Introductory Macroeconomics |
1 |
the government, corporation, banks which also take different economic decisions like how much to spend, what interest rate to charge on the credits... |
|