How to get maximum qualification for employee
Hi,
Below is the query to extract overall qualification details of employees, now I need to extract maximum qualification for all employees.
select distinct
papf.employee_number
, to_char(papf.START_DATE,'DD-MON-YYYY') "Date of joining"
,papf.full_name "Name"
,perq.title "Degree"
,perq.grade_attained "Grade"
,perq.status_meaning "Status"
,to_char( perq.start_Date, 'DD-MON-YYYY') "Date Start"
,to_char(perq.end_date, 'DD-MON-YYYY') "Date Completed"
,perq.name
,perq.establishment "Board/ University"
,qtype.RANK
from
APPS.PER_QUALIFICATIONS_V PERQ
,APPS.per_ALL_PEOPLE_F PAPF
,APPS.PER_QUALIFICATION_TYPES_V QTYPE
where papf.person_id = perq.person_id