Find out last 4 rows inserted rows ? Post category:sql query Retrieve data from emp table Emp table find out the last last 4 rows inserted The query select * from (select * from emp order by rowid desc) where rownum<=4; Please Share This Share this content Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window Opens in a new window You Might Also Like Write a query to find data between two time interval ? October 4, 2020 DISPLAY EVEN or ODD NUMBER OF RECORDS October 1, 2020 SQL-Find the unique records from two tables ? October 2, 2020 Leave a Reply Cancel replyCommentEnter your name or username to comment Enter your email address to comment Enter your website URL (optional) Save my name, email, and website in this browser for the next time I comment.