Question: Using a SET operator, Display all names that are used both as a last name and a first name. Example: Taylor Grant, Winston Taylor

Using a SET operator, Display all names that are used both as a last name and a first name. Example: Taylor Employees -O+ PK employee id first_name last_name Manages email phone_number hire_date job_id [FK] salary

Using a SET operator, Display all names that are used both as a last name and a first name. Example: Taylor Grant, Winston Taylor We want to display the name Taylor because it is used in both columns. Employees -O+ PK employee id first_name last_name Manages email phone_number hire_date job_id [FK] salary commission_pct manager_id [FK] department_id [FK] Heads Regions PK region id region_name - Hired -Attached- -Grouped- Jobs -O+ PK job id job_title min_salary max_salary Departments -O+ PK department id department_name manager_id [FK] location_id [FK] Countries PK country_id country_name region_id [FK] Detailed Ho PK PK -Located Ho-Resides Job_History employee id [FK] start date end_date department_id [FK] job_id [FK] -Associated- Locations PK location id street_address postal code city state_province country_id [FK]

Step by Step Solution

3.38 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

SELECT DISTINCT name FRO... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!