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- query to find out the distinct values from two tables October 12, 2020 Display the all employee details whose having duplicate salary October 2, 2020 Print 1,2,3.. to 10 in sql October 1, 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.