need the earliest date

[simian336]

My brain is not working today.

I need a query for the earliest day and with associated Account_ID.

Account_ID Service_Activation_Date
2100089506 1985-08-02 00:00:00.000
2100089506 2004-02-17 00:00:00.000
2100089506 2004-02-17 00:00:00.000
2100089511 1997-12-22 00:00:00.000
2100089511 2005-10-10 00:00:00.000
2100089511 2005-10-10 00:00:00.000
2100089514 1988-04-04 00:00:00.000
2100089514 1999-01-04 00:00:00.000
2100089514 1999-01-04 00:00:00.000

Answer.
2100089506 1985-08-02 00:00:00.000
2100089511 1997-12-22 00:00:00.000
2100089514 1988-04-04 00:00:00.000

Thanks

Simi

 

[simian336]

Nevermind... syntax problem.

Thanks

Simi