Re: Select first record from a table

D Huynh schrieb:

> is there a way to SELECT just the first record of a table that is constantly
> being truncated and repopulated? I've looked in several books and online
> help to no avail. TIA

Try

SELECT *
FROM MyTable
WHERE rownum < 2;

This returns only one row from this table which should be (as far as i know) the

first one in this table.
Dont use any ORDER BY or similar clauses.

Hope it will help you, let me know about it.

Regards,
Stephan Born

--
---------------------------------------------------------------
Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------