| Chapter 9 - Computer Science |
text |
N otes Example 9.17 The following query selects names of ... |
48 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
49 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Caution : If we miss the where clause in the UPDATE state... |
50 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
51 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
d) After dividing the amount into EMIs, find out the rema... |
60 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
9.8 F unctions in SQL In this section, we will understand... |
52 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
53 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
| D002 | Dzire | 673112.00 | VXI | 2018 | Petrol | | B001... |
54 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
55 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
categorised as Single Row functions and Aggregate functio... |
56 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
57 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
Example 9.18 In order to increase sales, suppose the car ... |
58 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
59 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
61 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
c) Display InvoiceNo, SalePrice and Commission such that ... |
62 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
63 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
RIGHT(string, N) Returns N number of characters mysql> SE... |
64 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
65 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
+---------------+----------------------------------+ | LE... |
66 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
67 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
include displaying the current date, extracting each elem... |
68 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
69 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
9.10 O perations on R elations N otes We can perform cert... |
78 |
|
Delete Content |
| Chapter 9 - Computer Science |
text |
b) If the date of joining is not a Sunday, then display i... |
70 |
|
Delete Content |
| Chapter 9 - Computer Science |
image |
/default_org/ncert_images/class-xii/c... |
71 |
|
Delete Content |