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 DISPLAY EVEN or ODD NUMBER OF RECORDS October 1, 2020 Turning a Comma Separated string into individual rows October 4, 2020 Query to display string in vertical form October 4, 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.