SQL - Select 3 most recent records to sysdate

[Lead_Head]

Hello all,

I need to select the three most recent records from todays date from a table.

How would I go about doing this??

Cheers,

 

[Lead_Head]

Yeah it's an Oracle database I'm querying from.

Rownum will only retrieve 3 records, I need to retrieve the 3 most recent dates from today per unique ID (which I have about 900).

Sorry I should have explained it better in my OP.

 

[Lead_Head]

Thanks for your efforts chaps, however I still can't get this to work.

Using the example above, each 'sequence#' will need to return 3 'first_time' records. There are more than 3 'first_time' records per 'sequence#', so I'm returning the first three closest to today.

Does that make sense??