Aggregate Function

[LAM986]

Hello,
I'm using the following query to get the below results.

SELECT MtgID, ClientID, Answer_Text, CreatedDate
FROM Results

MtgID ClientID Answer_Text CreatedDate
3025040 2190 No 1/12/2010
3025040 2190 No Response NULL



I need to group the results to get the last result. When I max(createdDate) and max(Answer_Text) I get the below result. The ANswer_Text should be No. Any help would be greatly appreciated. Thank you.

3025040 2190 No Response 1/12/2010

 

[LAM986]

I figured it out. Thanks anyway!!