Re: Address last rows in a table

A SQL RDBMS only is guaranteed to return data in a specific order if an ORDER BY clause is used. Granted, the order is usually that in which it was entered, bbut this is not always the case. You really need a column to order on - say a date column with SYSDATE inserted via a trigger when the row is updated. You then order by that column desc. Received on Thu Jan 28 1999 - 14:59:22 CST