hi guys can anyone explain to me what the codes in line 5 and 6 do? How does the WHERE works in those lines? Any explanation would be truly appreciated. Thanks in advance.
SELECT LAST_NAME ||', '|| FIRST_NAME AS "NAME" FROM EMPLOYEES E, (SELECT JOB_ID, MAX(SALARY) SALARY FROM EMPLOYEES GROUP BY JOB_ID) M WHERE E.JOB_ID = M.JOB_ID AND E.SALARY = M.SALARY