Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> SQL question: getting the 10 most recent records
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
![]() |
![]() |