Hi,
I have following table.
create table getmax as(
select 1 empid,2 mnth,5000 salary from dual union all
select 1 empid,10 mnth,6000 salary from dual union all
select 1 empid,12 mnth,5500 salary from dual union all
select 2 empid,3 mnth,7000 salary from dual union all
select 2 empid,7 mnth,6000 salary from dual union all
select 2 empid,12 mnth,5500 salary from dual
);;
I need to get which month employee has the highest salary.
Required Result
========================
EMPID MONTH SALARY
========================
1 10 6000
2 3 7000
=======================
Please help.