Slip 9 - D) Consider the above tables and execute the following queries: 1. Display area wise property details. 2. Display property owned by 'Mr.Patil' having minimum rate. 3. Delete all properties from “pune” owned by “Mr. Joshi”. 4. Update the phone Number of “Mr. Joshi” to 9922112233 who is having property at “Uruli Kanchan”. 5. Delete column address from Owner table.
Solution:
0 Comments