Depending upon the version, you may be able to use the analytical functions (8.1.6+)
to achieve what you want. I don't have a ready example, but the Oracle docs are pretty
good. If you want a less elegant solution, use an inline query, sort by the reverse
order (asc or desc depends on your requirements) and take the top 3. You can find
examples of the Top-N approach on www.optimaldba.com/library.html. Either the Top-N
Row or SQL Scripting Sorcery paper/presentation will have enough info to solve
the problem.
pfeffer wrote:
>
> hi
> is there a statement like last in mysql ?
> last returns a specified number of rows from a select.
> means if i do a select and i want only the last 3 lines.
> thx
> martin
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: pfeffer
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard
