Slip 25 - D) Consider the above tables and execute the following queries: 1. List the college wise staff. 2. Display the details of Teachers who are working in Dr. D Y Patil College and their specialization is “Computer”. 3. Display the designation of teacher whose name is “Mr Patil” and he is working in DPU college. 4. Display teacher wise salary. 5. Update an address of college to “Sant TukaramNagar” whose name is “MD College”.
Solution:
0 Comments