select top 10 from events order by date desc;
--
----------------------------------
Álvaro Morillas Correa
Programador Online
Hobbypress, S.A.
----------------------------------
"Juan Carlos Muro" <SADACIA_at_santandersupernet.com> escribió en el mensaje
news:ZkLt6.1690$CL6.54376_at_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:36:34 CST
