Selecting single row based on a condition
SELECT id, uid
FROM studenttable
GROUP BY id, uid
HAVING SUM( CASE WHEN subject='English' 
                 THEN 0 
                 ELSE 1 
            END ) = 0