Android : Select data between two dates and select only the updated date

I have a table employee_tbl with this data

emp_no,date_posted

1,2014,08,01 

1,2014,08,02

3,2014,08,01

3,2014,08,02

5,2014,08,01

5,2014,08,02

i want to select the employee data where the date is between 2014,08,01 and 1,2014,08,03 so i will get them all.

1,2014,08,01

1,2014,08,02

3,2014,08,01

3,2014,08,02

5,2014,08,01

5,2014,08,02

but i only want to get the employee with the latest date like this

1,2014,08,02 

3,2014,08,02

5,2014,08,02

how will i query this one? please help.