Question: Use Microsoft access Q1. Select name, ID, Address from Customer where not city=IBRA; Q2. Select * from Customer where ID Between 1 and 3; Q3.
Use Microsoft access
Q1. Select name, ID, Address from Customer where not city=IBRA;
Q2. Select * from Customer where ID Between 1 and 3;
Q3. Update Customer set City= Muscat where ID= 5;
Q4.Delete from Customer where name= Ahmed and city=IBRA;
Q5.Select * from Customer order by Name Desc;
Q6.
Part C: Write appropriate queries for the following result (Total Marks=5)
| ID | Name | City | | Salary |
| 1 | Fatima | Sur | 1@xyz.com | 1000 |
| 2 | Mohammed | Salalah | 2@xyz.com | 800 |
| 3 | Khalid | Nizwa | 3@xyz.com | 1000 |
| 4 | Ahmed | IBRA | 4@xyz.com | 900 |
| 5 | Abdullah | Muscat | 5@xyz.com | 400 |
Use the above table to create Query
Question 16
Not yet answered
Marked out of 1.00
Flag question
Question text
| Name | City |
| Fatima | Sur |
| Mohammed | Salalah |
| Khalid | Nizwa |
| Ahmed | IBRA |
| Abdullah | Muscat |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
