Question

How to select only rows where a column value is maximum?

Answer 1

Suppose you have a table called students contains Student Name, English Mark & Math Mark and you need to select the student with the highest mark in English.

SELECT *

FROM Students

where EnglishMark=

(select Max(EnglishMark) from Students) ;