| Class XII |
Computer Science |
Computer Science |
9 |
5 STR STD | 2017 | CNG | 397829.6 | | E002 | EECO | 654914.00 | CARE | 2018 | CNG | 733503.7 | | S001 | SWIFT | 514000.00 | LXI | 2017 | Petrol | 5... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the SalePrice, Insert the values to the newly added column Commission and then display records of the table SALE where commission > 73000. mysql> U... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
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 UC... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
string functions. Using the table a) Display customer name in lower case and customer EMPLOYEE from CARSHOWROOM email in upper case from table CUST... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
/) d) Display emails after removing the domain name on date functions? extension “.com” from emails of the customers. mysql> SELECT TRIM(“.com” fro... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
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 of Sale +... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
time1. 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 Select, ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
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 |
E007 |659982.00 | 79198.84 | | I00005 | E001 | C0003 | 2018-12-20 | Credit Card | E002 |369310.00 | 44318.20 | | I00006 | S002 | C0002 | 2019-01-30... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
once. mysql> SELECT PaymentMode, Count(PaymentMode) FROM SALE GROUP BY Paymentmode HAVING COUNT(*)>1 ORDER BY Paymentmode; +--------------+--------... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
shown in Table 9.20. StructuredQueryLanguage(SQL) 169 Reprint 2026-27 N otes Table 9.20 DANCE U MUSIC +------+---------+-------+ | SNo | Name | Cla... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
8A | +------+---------+-------+ 9.10.4 Cartesian Product (X) Cartesian product operation combines tuples from two relations. It results in all pair... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
3 | Lavanya | 7A | | 4 | Sanjay | 7A | 3 | Lavanya | 7A | | 1 | Aastha | 7A | 4 | Sanjay | 7A | | 2 | Mahira | 6A | 4 | Sanjay | 7A | | 3 | Mohit |... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
will be the Table 9.23 having degree 6 and cardinality 20. b) From the all possible combinations of tuples of relations DANCE and MUSIC display onl... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
we need to define Ucode as foreign key in the Price table while creating this table. Table 9.25 Uniform table +-------+-------+--------+ | Ucode | ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
with condition in From clause. Hence no condition needs to be given in where clause. c) Explicit use of NATURAL JOIN clause The output of queries (... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
may use any relational operators to combine tuples of two tables. Summ ary • Database is a collection of related tables. MySQL is a ‘relational’ DB... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
a set of records as a whole and return a single value. Examples include COUNT, MAX, MIN, AVG and SUM. • GROUP BY function is used to group rows of ... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the movies showing only MovieID, MovieName and Total_Earning. Total_ Earning to be calculated as the sum of ProductionCost and BusinessCost. c) Lis... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
DML statement. g) Now create another table MATCH_DETAILS and insert data as shown below. Choose appropriate data types and constraints for each att... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
provision so that the data can be entered in the COST table only if it is already there in the UNIFORM table. c) Further, they should be able to as... |
|
| Class XII |
Computer Science |
Computer Science |
9 |
the following: a) Add a new column Discount in the INVENTORY table. b) Set appropriate discount values for all cars keeping in mind the following: ... |
|
| 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 ... |
|