Re: MAX() Select Problem

[sp]

The following gives me the max QuizPercent out of the series but it does not give me the QuizPercent which is associated with the MAX(QuizDate)

SELECT MAX(QuizDate) as QuizDate, MAX(QuizPercent) AS QuizPercent, QuizID
FROM Test_Board_Biomed
WHERE Customer_ID = 21
GROUP BY QuizID

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---