How get earliest timestamp?

[mscertified]

I have a table with a date/time column.
I need to retrieve the earliest timestamp record.
I'm currently using SELECT MIN(timestamp), is this correct?

Thanks.

 

[Klatuu]

Yes.
But, are you filtering the query so it returns only one record?
If not, then you would need SELECT TOP 1 MIN(timestamp)
But then, I am thinking if you want to return only one value, why not use a
DMin function instead?

 

[mscertified]

Good point. I had ignored the possibility of duplicate timestamps, but I
suppose it could happen!

 

[Paul Shapiro]

Not an issue. If your query is ONLY referencing aggregate functions, then
only a single row will be returned. Even if there are duplicate data values,
there's still only a single value for the min().