Slip 5 - D) Consider the above tables and execute the following queries: 1. Find details of all customers whose loan_amt is greater than 10 lakh. 2. List all customers whose name starts with 'D' character. 3. List the names of customer in descending order who has taken a loan from Pimpri city. 4. Display customer details having maximum loan amount. 5. Update the address of customer whose name is “Mr. Patil” and loan_amt is greater than 100000.

Solution:

Post a Comment

0 Comments