Dear all Best RegardsSolutionselect from Employee where man
Dear all,
Best Regards,
Solution
select * from Employee where manager = \'Bill\';
EmployeeForm
EmployeeId 1
Empname Chris
Salary $2300.00
Manager Mathew
Hiredate 5/18/2016
| EmployeeId | EmpName | Salary | Hiredate | Manager |
|---|---|---|---|---|
| 1 | Chris | $2,300.00 | 5/18/2016 | Mathew |
| 2 | Smith | $3,400.00 | 6/14/2016 | Mathew |
| 3 | Samara | $1,500.00 | 7/27/2016 | John |
| 4 | Anita | $2,000.00 | 3/16/2016 | Bill |
| 5 | Martha | $3,300.00 | 7/19/2016 | Bill |
