Originally posted by Jane Somerfield:
Can I do this?
select e.NAME, SALARY from EMP where SALARY = (select max(SALARY) from EMP e);
Does the scope of the alias "e" in the subquery matter?
I am confused. Why the need for the alias at all in that query?