Which select statement I can use to achieve the max salary of an employee where
I wrote this one but I think there is something better
select salaries.salary , salaries.from_date
from salaries
where emp_no='10789'
group by from_date ;
1 answers ( 0 marked as helpful)
Hi Islam!
Thanks for reaching out.
You can use the following code:
SELECT
max(s.salary), s.from_date
FROM
salaries s
WHERE
emp_no = '10789'
Hope this helps.
Best,
Tsvetelin
