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.
I know this would have been answered many times, but i was not able to go
thru the archieves.
Plz help me.

--
regards,
hari
__
/ / __ _ _ _ _ __ __ -o)
/ /__ / / / \\// //_// \\ \\/ / /\\\\ Making things happen
/____/ /_/ /_/\\/ /___/ /_/\\_\\ _\\_v-

-------------------------------------------------------------------