>>>>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