>>>>

>>>>select * from tests t1 ;
>>>>	where ;
>>>>	score = (select min(score) from tests t2 where t1.student = t2.student) ;
>>>>	or ;
>>>>	score = (select max(score) from tests t2 where t1.student = t2.student)
>>>>
>>>>* Not in older versions
>>>>select t1.* from tests t1 ;
>>>>	INNER join ;
>>>>	(select student, max(score) as maxScore, min(score) as minScore ;
>>>>	from tests group by 1) t2 ;
>>>>	on t1.student = t2.student and (t1.score = t2.maxScore or t1.score = t2.minScore)
>>>>

Cetin
>>>
>>>The last one is nice, but should you also group by testname in both cases?
>>
>>No. Read the question.
>>Cetin
>
>Well, for this particular data sample we don't need to group by testname. If we would have chem 5 and math 0, we would.

It's not related to data sample, it's related to the wanted result. That's how SQL works. Different needs, different SQL.
Cetin