top 10 selection ... (quickie)

[callhandler]

I have a simple table with dates in it (lots of them).

How do I write a query to select the 10 most recent dates in the list?

 

[DanJR]

Hi there,

SELECT top 10 myTable.myDate
FROM myTable
ORDER BY myTable.myDate DESC

Cheers,
Dan

 

[callhandler]

OK, I apologize. I over simplified the problem.

The date field has data in the format:
mm/dd/yy hh:mm (ie it has time as well)

I need to select the 10 most recent days, not the 10 most recent fields.