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 sql – how to split full name into first and middle and last name October 3, 2020 Display top 7 records from emp table October 1, 2020 Retrieve the department number and salary ‘s duplicate records From emp-table ? 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.