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
Nilesh ShahPosted Dec 19, 2017, 8:32 AM