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