Re : 20 row retrieval
Hey
Please ignore my previous mail.The below
one will retrieve 20 rows from the syscolumns(you can use it for any
table) table.
SELECT *
from syscolumns SC1
where 20 > (SELECT count(*)
FROM syscolumns SC2
WHERE sc1.rowid > sc2.rowid)
Have Fun,
Harinath Venkata
PSI DATA SYSTEMS Ltd.
Phoenix