Re: Get the last record alone from the select statement.

> 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