OTBI - How to get the records with MAX effectivedate

Content

How do I query all the records with  MAX effectivedate from the below table. After running the query on the below table I should have only the last 2 rows which is having the max effective date of 7/25/17

Person NUmber	Effective Date
100010	7/15/17
100015	7/18/17
100020	7/11/17
100021	7/25/17
100022	7/25/17

Below query seems to throw error

select "Payroll - Payroll Balances Real Time"."Worker"."Person Number" ,   "Payroll - Payroll Balances Real Time"."Balance Value Details"."Effective Date" 
        from "Payroll - Payroll Balances Real Time"
   where 
    "Payroll - Payroll Balances Real Time"."Balance Value Details"."Effective Date" = 
   SELECT MAX("Payroll - Payroll Balances Real Time"."Balance Value Details"."Effective Date") FROM "Payroll - Payroll Balances Real Time"