Entry

A table taking online data has fields tagid, date, value. I want last 10/ 20 records records of it

Apr 20th, 2004 19:34
Eyzen Medina, Shampa Dey,

Make use of rownum statement to enumerate the reecords in a table.
Select Temp.* FROM
(Select rownum NId , a.* from Tablename a) Temp
Where Temp.NId between 1 AND 10;
Eyzen