How toFetch Last Record Inserted against Employee_ID

Question

Hey,

 

I have one  table in which every year employee increment records inserted.I have requirement to fetch last record inserted in  table. 

 

I am trying this query in oracle

 

Select * from table

where   employee_id=111

order by Next_Increment_date desc

offset 0 rows fetch next 1 rows only

 

 

Thanks in advance