Sql Query - What is the query for this?

[NewsBot]

We're using Sql Server 2K5.

 

I have a table containing dates for an events table.* The dates table contains one or more dates for a single event.* What is the query on the dates table that returns only 1 date (the earliest date) for each event.

 

So the the dates table looks like this:

id* event_id* date

1** 37********** 2007/02/01

2** 37********** 2007/01/01

3** 38********** 2006/01/01

4** 39********** 2007/04/01

5** 39********** 2006/01/01

 

I looking for a dates table resultset of:

id* event_id* date

1** 37********** 2007/01/01

3** 38********** 2006/01/01

5** 39********** 2006/01/01

 

Notice there is only* one entry for each event_id and this date represents the earliest time for the event.

 

Thanks for the query.

 

 

More...

 

View All Our Microsoft Related Feeds