D
Darren
I am writing a subquery using the all statement and it seems to be giving a
problem.
SELECT EID, Salary, Department
FROM tblAccounts
WHERE Salary > ALL
(SELECT Salary
FROM tblAccounts
WHERE Department = "Sales");
The problem is that the subquery is not taken in to account. So the answer
shows for all departments not just for the sales department. This also
happens when I use ANY instead of ALL.
Please help.
problem.
SELECT EID, Salary, Department
FROM tblAccounts
WHERE Salary > ALL
(SELECT Salary
FROM tblAccounts
WHERE Department = "Sales");
The problem is that the subquery is not taken in to account. So the answer
shows for all departments not just for the sales department. This also
happens when I use ANY instead of ALL.
Please help.