Answer to Question #42973 in Other Programming & Computer Science for faisal
Question #42973
Perform the following DML operations on the table:
1. Insert values for the table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table given below:
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
2. Based on the customer table given above update the salary to 20000 whose salary is less than that.
Based on the customer table given above Fetch ID,
3. Name and Salary fields from the CUSTOMERS table for a customer with name Hardik.
1. Insert values for the table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table given below:
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
2. Based on the customer table given above update the salary to 20000 whose salary is less than that.
Based on the customer table given above Fetch ID,
3. Name and Salary fields from the CUSTOMERS table for a customer with name Hardik.
Expert's answer
Not answered
Need a fast expert's response?
Submit orderand get a quick answer at the best price
for any assignment or question with DETAILED EXPLANATIONS!
Comments
Leave a comment