问题描述:

I have a table called dbo.files with a column created_time that contain values like:

2012-05-21 13:28:56.960

This tables has over 138 million rows.

I would like to find the oldest value in the table within the created_time column. This would tell me when I first started writing to the table.

What I have tried so far as a test

select count(*)

from dbo.files

where created_time < '2010-01-01 00:00:00.000'

this comes back with 0

How can I find the oldest value in that column?

网友答案:
SELECT min(created_time) 
FROM dbo.Files
相关阅读:
Top