Below is My Table:
Image 1.
Now Query Is:
SELECT YEAR, MAX(AMOUNT) AS MAXSALARY,
MIN(AMOUNT) AS MINSALARY
FROM EMPLOYEE_SALARY
GROUP BY YEAR
Image 2.
Find MAX & MIN Salary By Year
Loading
SELECT YEAR, MAX(AMOUNT) AS MAXSALARY,
MIN(AMOUNT) AS MINSALARY
FROM EMPLOYEE_SALARY
GROUP BY YEAR
Join the conversation! Your thoughts help the community grow.