we can get the recent or latest 10 rows from oracle database based on the sysdate i.e current date.
below query will give you the today's recent 10 transactions.
SELECT *
FROM (SELECT ID,CREATED FROM EMP
WHERE TRUNC(CREATED)>=TRUNC(SYSDATE) ORDER BY CREATED DESC )
WHERE ROWNUM <= 10
No comments:
Post a Comment
Thanks for giving comments!!