Re: Get the last record alone from the select statement. - Mailing list pgsql-novice

> Hi all,
>   I have a doubt in limit clause. With limit and offset i can get the
> first few records from the select statement. Suppose i want to get the
> last record alone from the select, how can i achieve it.

=> select your_fields from your_table where your_condition order by
oid desc limit 1;

regards,
bhuvaneswaran