Help With Basic SQL Query

Question

I have a table with columns

ID, DateStamp

and the ID need not be unique.

How do I write a query that will give me a list of IDs with the minimum DateStamp and the maximum DateStamp?

So, for example, for a given ID, the output may look like:

938423, 1/1/2000, 12/13/2003

[I am running SQL Server 2000.]

Answer 1

The following should do it:

SELECT ID, MIN(DateStamp), MAX(DateStamp)
FROM TableName
GROUP BY ID

EDIT Added from clause for clarity, be sure to change TableName to the actual table name