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 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
SELECT DISTINCT name FRO... View full answer
Get step-by-step solutions from verified subject matter experts
