Question: Find the name, status and yearsofservice in a table name Employees whose status is either full time or part time but yearsofservice must be at
Find the name, status and yearsofservice in a table name Employees whose status is either full time or part time but yearsofservice must be at least 25
| . | ||
| a) SELECT name, status, yearsofservice FROM Employees WHERE status = full time AND status = part time OR yearsofservice >= 25 | ||
| b) SELECT name, status, yearsofservice FROM Employees WHERE status = full time OR status = part time OR yearsofservice >= 25 | ||
| c) SELECT name, status, yearsofservice FROM Employees WHERE status = full time OR status = part time AND yearsofservice >= 25 | ||
| d) SELECT name, status, yearsofservice FROM Employees WHERE status = full time AND status = part time AND yearsofservice >= 25 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help