Hi, If I want to find out highest score student from each class, how can I do that in MySQL? Assume the table looks like:
classId INT, studentId INT, score INT In the case of multiple students from the same class has the same highest score, I would like to get the first one whose studentId is the smallest. I tried to use sub-query, but in the case of students of same highest score in the same class, they all get returned - I only want one from each class. Is it possible? Thanks a lot HT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
