77 926
Assignments Done
98,3%
Successfully Done
In August 2019

Answer to Question #43167 in Databases | SQL | Oracle | MS Access for Rohit Arya

Question #43167
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.

Pleaze send answer of this question.
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions