Finding first date

Question

Post reply

Finding first date

ehlinger

Hall of Fame

Points: 3585
More actions
June 8, 2005 at 2:44 pm

#89526

I have a data set that contains entity ids (these may be in the table multiple times) and also date information. So I may have an entity id of 1 3 times with three different dates. What I am trying to do is return each unique entity id along with the earliest date associated with that id.
I know that we used to do this in Access with a Group By and choosing First but I can't figure out how to go about it in SQL. Any suggestions would be great. Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Select id, min(DateCol) as EarlyDate

from dbo.YourTable

Group by id

ehlinger Hall of Fame Points: 3585 More actions · Answer 2

Thank you very much Remi. I was making it way to complicated to ever figure out it was that easy. Thanks again.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

The simplest solutions are always (almost) the best.

HTH.

ron k SSCertifiable Points: 6103 More actions · Answer 4

From Google:

50 First Dates (2004)

50 First Dates - Cast, Crew, Reviews, Plot Summary, Comments, Discussion, Taglines, Trailers, Posters, Photos, Showtimes, Link to Official Site, Fan Sites.

http://www.imdb.com/title/tt0343660/ - 53k - Jun 7, 2005 - <A class=fl href="http://72.14.207.104/search?q=cachehO4LBHxjPAJ:www.imdb.com/title/tt0343660/+first+date&hl=en target=nw">Cached - Similar pages

First Date

A teenager is going out on her first date, and she discusses the details with her father.

http://www.esl-lab.com/dating/datingrd1.htm - 9k - Cached - Similar pages

Guys Dating Secrets, Dating Tips, Kissing Women, Love, Romance ...

Art of Kissing Single Women on Your First Date Take her to paradise with your kiss!!! At the end of a first date comes that awkward moment when you must ...

http://www.links2love.com/guys.htm - 53k - Cached - Similar pages

Just couldn't resist