Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

TABLE: employee_t Which query will show all employees who are managers? Select all that apply. SELECT DISTINCT e.* FROM employee_t e JOIN employee_t m on

TABLE: employee_t Which query will show all employees who are managers? Select all that apply. SELECT DISTINCT e.* FROM employee_t e JOIN employee_t m on e.employee_id = m.manager_id ; SELECT * FROM employee_t WHERE employee_id = (SELECT manager_id FROM employee_t); SELECT * FROM employee_t WHERE employee_id IN (SELECT DISTINCT manager_id FROM employee_t); SELECT * FROM employee_t WHERE employee_id = manager_id ;
image text in transcribed
TABLE: employee_t Which query will show all employees who are managers? Select all that apply. SELECT DISTINCT e. FROM employee_t e JOIN employee_t m on e.employee_id = m.manager_id ; SELECT * FROM employee_t WHERE employee_id = (SELECT manager_id FROM employee_t); SELECT * FROM employee_t WHERE employee_id IN (SELECT DISTINCT manager_id FROM employee_t); SELECT * FROM employee_t WHERE employee_id = manager_id

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions