SQL Query MAX Value column


SELECT max( mark ) FROM `student`

return the maxium value from a table named student with fieled mark. max value of the field is returned. 


SELECT * FROM `student` WHERE mark=(select max(mark) from student)
resutrn all fields in the database where mark is maximum