Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How toFetch Last Record Inserted against Employee_ID
Amit Singh
Dec 19 2017 6:45 AM
154
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
can you please post the er diagram for library system
Datetime Conversion