Amit Kumar Singh

Amit Kumar Singh

  • 381
  • 3.9k
  • 198.3k

How toFetch Last Record Inserted against Employee_ID

Dec 19 2017 6:45 AM
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 
 

Answers (1)