Question: how to find the difference between two rows in oracle?
Answer: select * from (select a. * from X a where ROWNUM = 1 order by last_updt_date desc ) minus select * from (select b. * from X b where ROWNUM = 2 order by last_updt_date desc );