I was doing good in this book until I got to subqueries.
I do not have a clue on these problems:
1. Write a query to display the name, department number, and salary of any employees whose department number and salary match the department number and salary of any employee who earns a...
How come I get no rows selected for this query?
6-1 Write a query to display the employeee name and hire date for all employees in the same department as Blake. Exclude Blake.
select ename, hiredate
from emp
Where job =
(select job
from emp
where ename In ('Blake'));
6-2 Create a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.