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...
Top Oracle Application Developer interview questions & answers
Popular interview questions of Application Developer
Top HR questions asked in Oracle Application Developer
Stay ahead in your career. Get AmbitionBox app
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
Get AmbitionBox app