Loading

Last Updated Records from Database

Ajith Sn

Required Last few Updated Records from Databse table & those Updated records must fetch from last fetched record ? Im having Changed_on field in Table. Is i want store last Changed_on Record in Buffer ? then how to call in query ?

Can anybody help me?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rathrola Prem Kumar9y ago
Check this syntax
SELECT *
FROM (SELECT *
FROM emp
ORDER BY last_updated desc)
WHERE rownum <= 20