Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL question: getting the 10 most recent records

SQL question: getting the 10 most recent records

From: Juan Carlos Muro <SADACIA_at_santandersupernet.com>
Date: Tue, 20 Mar 2001 16:13:45 GMT
Message-ID: <ZkLt6.1690$CL6.54376@telenews.teleline.es>

Hello. This is an SQL question.

I have a table like this:

    create table events ( event_id number, event_d date );

I want to get the 10 most recent events (by 'event_date' criteria) with a select. Is that possible? Something like:

    select <the 10 most recent> from events order by date desc;

Can U help me?

Thank you:
J. Carlos Muro Received on Tue Mar 20 2001 - 10:13:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US