SQL-QUERY, There is a department table with department name ,department ID and with staff members ID who are working in department and also there is a Staff members table with staff member name, staff member ID and department ID he works , so basically there is a many to many relationship between them so you need to write a two SQL queries in which first query is you need to retrieve all the departments a staff member works and second query is you need to retrieve all the staff members works for each department

Be the first one to answer
Add answer anonymously...
Oracle Application Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+

Reviews

4 L+

Interviews

4 Cr+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter