Martin Giffy D'SouzaProtalkapex.com·Jan 5, 2024How to Get a Non-Aggregate value in an Aggregate QuerySuppose you want to find the maximum salary for each job in the emp table. This is very easy using using the max aggregate: select job, max(sal) max_sal from emp group by job order by job ; JOB MAX_SAL --------- ------- ANALYST 3000 CL...4 likes·520 readsOracleAdd a thoughtful commentNo comments yetBe the first to start the conversation.
