Tuesday, May 19, 2015
SQL Assignment08 - Delete Statement
1. Delete from customers.
2. Delete depositor of branches having number of customers between 1 and 3.
3. Delete branches havinng average deposit less than 5000.
4. Delete branches having maximum loan more than 5000.
5. Delete branches having deposit from Nagpur.
6. Delete deposit of Anil and Sunil if both are having same branch.
7. Delete deposit of Anil and Sunil if both are having living city Nagpur.
8. Delete deposit of Anil and Sunil if both are having same living city.
9. Delete deposit of Anil and Sunil if they are having less deposit than Vijay.
10. Delete deposit of Vijay.
11. Delete deposit of Ajay if Vijay is not a depositor.
12. Delete customer from BOMBAY city.
13. Delete depositors if the branch is VIRAR and depositor name is Ajay.
14. Delete depositors having deposit less than 500.
15. Delete borrower having loan more than 10000.
16. Delete borrower having loan more than 1000 and branch KAROLBAGH.
17. Delete the name of those depositor of VRCE branch who live in the city BOMBAY.
18. Delete borrower having branch name KAROLBAGH
19. Delete borrower of branches having average loan less than 1000.
20. Delete borrower of branches having the minimum number of customers
Like the Facebook Page & join Group
For WHATSAPP group , drop a msg to 91-88-00-906098