does SELECT support a parameter that would allow the selection of the single oldest record in the table? Something like

select min(datetimefield) from mytable

but retrieving all the fields?

Thanks