I have the following table structure ,
name || description || timestamp varchar varchar date
time stamp column consists of time the row is added
Now i need to fetch the recently entered 5 records .. How should i query the table .
Note: i am using oracle 10g
select * from table orderby timestamp desc where rownum<6
Is that right approach ??
Thanks in advance !!