Oracle SQL Interview Questions

Write a SQL query to find the last record inserted in the table

Solution

Select * from (select * from HR.employees order by rownum desc) where rownum<2;